Configuring the ADO Client : Using Interactive SQL for ADO : Interactive SQL Commands for OLEDBISQL

Interactive SQL Commands for OLEDBISQL

This section describes the commands available when using OLEDBISQL.

file_name cmdfile

Reads the commands from the given command file.

connect

This command brings up the Data Link Properties dialog box, in which you can select the data provider and supply the required connection information.

1. Select DataDirect SSIS OLE DB OpenAccess SDK and then click Next.

2. Click the All tab and edit the Extended Properties attribute to the string to specify the host, port and the ServerDataSource. For example, type:

host=mysdkserver;port=19986;ServerDataSource=Default

3. Click the Connection tab. Provide the user name and password.

4. Click Test Connection.

5. Click OK to return to the ISQL prompt.

disconnect

Disconnects from the data source.

echo information

Echoes the given information.

errfile file_name

Errors are written to the file_name file.

# [comment]

Ignores the text following the pound sign(#). This is useful when OLEDBISQL is set up to run automated test scripts that can be documented with comment lines. Note that if the -e option is enabled, the comment will be echoed to the standard out.

sql_smt;

Executes only the supported set of SQL statements. This command supports the following DML statements (SELECT, INSERT, UPDATE, DELETE, CALL) and DDL statements (CREATE TABLE, DROP TABLE). The SQL statement can be entered on multiple lines and must be terminated by a semicolon.

exit

Ends the interactive SQL session after closing any active connection. Functionally equivalent to QUIT.

help

Provides online help for the supported commands.

quit

Ends the interactive SQL session after closing any active connection. Functionally equivalent to EXIT.

resfile {file_name}

Logs the results to the given file. If the file name is not specified, the command logs the results to standard output.

repeat number
command
end

Repeats the given command specified number of times. Any supported command can be repeated, except another repeat command.

ncmdfile file_name

Reads the Unicode commands from the given command file. The command file must be in UTF-8 format.