Sybase IQ database utilities that communicate with the server (rather than acting directly on database files) do so using Embedded SQL. They follow the procedure outlined in “How Sybase IQ makes connections” when connecting to a database.
Many of the administration utilities obtain the connection parameter values by:
Using values specified
on the command line (if there are any). For example, the following
command starts the collation utility on the sample database on the
default server, using the user ID DBA and
the password SQL and the asiqdemo.col collation
file:
dbcollat -c "uid=DBA;pwd=SQL;dbn=asiqdemo" c:\temp\asiqdemo.col
Using the SQLCONNECT environment variable settings if any command line values are missing. Sybase IQ database utilities do not set this variable automatically. This option provides better password security than other methods. For a description of the SQLCONNECT environment variable, see Chapter 1, “File Locations and Installation Settings” in Sybase IQ Reference Manual.
Prompting you for a user ID and password to connect to the default database on the default server, if parameters are not set in the command line or the SQLCONNECT environment variable.
For a description of command-line options for each database utility, see Chapter 3, “Database Administration Utilities” in the Sybase IQ Utility Guide.
