Specify these options when invoking Interactive SQL Classic from a command prompt.
Option |
Description |
|---|---|
-c "keyword=value; ..." |
Specifies connection 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.
|
-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. |