Sybase Adaptive Server Anywhere - Page 125

Chapter 4 Database Administration Utilities
107
–host Specify the hostname or IP address of the computer on which the
database server is running. You can use the name localhost to represent the
current machine.
-jConnect Use the Sybase jConnect JDBC driver to connect to the
database. This is the default method, and is recommended in most
circumstances.
–nogui Run Interactive SQL in a command-prompt mode, with no
windowed user interface. This is useful for batch operations.
In this mode, Interactive SQL sets the program exit code to indicate success
or failure. On Windows operating systems, the environment variable
ERRORLEVEL is set to the program exit code. The exit codes are as
follows:
Program exit code Description
0 Success.
1 General failure. At some point, a SQL or Interactive SQL
statement did not execute successfully and the user chose
to stop executing SQL statements. Alternatively,
Interactive SQL noted an internal error in.
5 Interactive SQL was terminated by the user. When an
error occurs during execution, the user is prompted to
ignore it, stop, or exit Interactive SQL. If the user opts to
exit, the program returns code 5. Code 5 is also returned
if an error occurs and the Interactive SQL option
ON_ERROR is set to EXIT.
9 Unable to connect.
255 Bad command line. The command line contained
incomplete or invalid switches.
–ODBC Connect using the JDBC/ODBC bridge. If you do not specify this
option, Interactive SQL connects using jConnect.
–port Specify the port number on which the database server is running.
The default port number for Adaptive Server Anywhere is 2638.
–q Do not display output messages. This is useful only if you start
Interactive SQL with a command or command file.
–x Scan commands but do not execute them. This is useful for checking
long command files for syntax errors.
$ For or detailed descriptions of SQL statements and Interactive SQL
commands, see "SQL Language Elements" on page 219.