Specify these options when invoking Interactive SQL Classic from a command prompt.
Option |
Description |
|---|---|
-c "keyword=value; ..." |
Specifies connection parameters. See System Administration Guide: Volume 1 > Connection and Communication Parameters. If you do not specify any connection parameters, the environment variable SQLCONNECT is used. If Interactive SQL cannot connect, enter the appropriate parameters in the dialog box that appears. Note: Sybase recommends that you always specify connection
parameters for Interactive SQL Classic instead
of relying on defaults, whether you specify them in a command line
or an initialization file such as .odbc.ini on
UNIX, or odbc.ini on Windows. If you start
more than one database on a server, for example, specify the database
name, and in a network with subnets, specify the communications
protocol parameter with host number. See System Administration Guide: Volume 1 > Sybase IQ Connections.
|
-d delimiter |
Specifies a command delimiter. By default, the delimiter is the semi-colon. |
-q |
Quiet mode—does not display output messages. This option is useful only if you start Interactive SQL Classic with a command or command file. |
-r |
Returns the error “Not enough fields allocated in sqlda” if the defined result set of the stored procedure does not match the actual result set. This option may be useful when you are querying stored procedures. |
-x |
Checks syntax only. Scans commands but does not execute them. You may find this option useful for checking long command files for syntax errors. |