skip to main content
Configuring the ADO Client : Using Interactive SQL for ADO
 

Using Interactive SQL for ADO

OLEDBISQL supports a command line interface to connect to a data source, execute SQL statements, and retrieve results for display on a terminal. You can change the code page by setting value of CodePage item under [COMMON] section in the configuration file.
The provider name that you specify in the command line option allows it to connect to OpenAccess SDK data sources that are served by OpenAccess SDK Servers.
The command format to run a SQL statement to query/modify a data source is a SQL statement terminated by a semicolon:

ISQL> SQLstatement ;
In this section: 
* Starting and Stopping OLEDBISQL
* Interactive SQL Command-line Syntax
* Interactive SQL Commands for OLEDBISQL
* Redirecting Output from OLEDBISQL
* Example of an Interactive SQL Session