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

Using Interactive SQL for ODBC

The Interactive SQL tools are OpenAccess SDK Client programs for accessing data resources managed by OpenAccess SDK Servers. These tools use a command line interface to connect to a data source, execute SQL statements, and retrieve results for display on a terminal. The tools can also be used to verify installation and to execute SQL commands interactively or from a file.
ODBCISQL supports a command line interface to connect to a data source, execute SQL statements, and retrieve results for display on a terminal.
The command format to run a SQL statement to query or modify a data source is a SQL statement terminated by a semicolon:

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