Command

Description

aexec

(ORACLE  & ODBC Only) The aexec command executes the astmt statement for any aval statements that remain after the last batch transfer, then terminates batch mode.

asize

(ORACLE Only) Sets the number of rows of data you want to transfer in each batch operation.

astmt

(ORACLE & ODBC Only) This command to identify the INSERT, UPDATE, or DELETE statement you want used in subsequent batch commands.

aval

(ORACLE & ODBC Only)  This command to provide data values for use with an SQL statement in a batch operation.

binddb

(DB/2 Only.) Disconnects from the currently running  database; runs DB/2  dynamic bind routine; and connects to the new database. Retained for compatibility with SQL Server and ORACLE.

login

Logs the user into a database server. Not applicable to DB/2.

startdb

DB/2: Connects to a database. SQL Server: Connects to a particular database on the current SQL Server. This is the same as the TRANSACT-SQL use command. ORACLE: Closes the current database and switches to another.

stopdb

(DB/2 & ODBC Only.) Disconnects from the currently running database.

columns

(ODBC Only.) Provides information regarding the columns for a specified table.

datasources

(ODBC Only.) Returns a list of ODBC data sources that are accessible to the User.

foreignkeys

(ODBC Only.) Provides a list of columns that are foreign keys within a specified tables.

indexes

(ODBC Only.) Lists the columns within a table that have been created as indexes.

primarykeys

(ODBC Only.) Provides a list of columns that are primary keys within a specified tables.

tables

(ODBC Only.) Lists tables with a specified scheme and/or database catalogue.

autocommit

(ODBC Only.) Determines whether rows should be immediately committed to a table, or left until explicitly committed. Default is "ON".

bindfile

(DB/2 Only.) Sets the location of the bind file.

break

(SQL Server Only.) Sets the break string that is to be prepended to a compute row.

error

Sets the error string.

exit

Terminates the program.

fs

Sets the field separator for subsequent queries.

info

Sets the information string.

maxwidth

Sets a maximum width that will be returned by subsequent widths commands.

message

(SQL Server Only.) Sets the message output string.

null

Sets the null indicator string.

prompt

Sets the prompt string.

rs

Sets the record separator for subsequent queries.

set

Sets the display width for the specified column of a subsequent select statement.

startq

Clears all existing column formats (widths), and resets them to their default widths.

terminator

SQL Server and ORACLE Only. Sets the input statement terminator to the specified character.

verbose

Turns the verbose error reporting on or off.

display

Displays the current configuration state.

names

Parses the select statement and delivers an informational message describing the name of each column that will appear in the result table.

types

Parses the select statement and delivers an informational message describing the SQL data type of each column that will appear in the result table.

widths

Causes the program to parse the select statement and deliver an informational message describing the maximum possible length of each column selected, with each column's width expressed as a set command.

rowcount

(ODBC Only.) Returns the number of rows affected by the previous, UPDATE, INSERT or DELETE SQL Statement.

commit

(ODBC Only.) When autocommit is off, this command tells the Data Manager to apply all the changes to the table that have been made since the previous commit or rollback command.

rollback

(ODBC Only.) When autocommit is off, this command tells the Data Manager to back out all the changes to the table that have been made since the previous commit or rollback command.