SAP Sybase IQ database utilities that
communicate with the server (rather than acting directly on database files) do so using
Embedded SQL.
How Database Utilities Obtain Connection Parameter Values
Many of the administration utilities obtain the connection
parameter values by:
Using values specified on the command line (if any). For example, the
following command takes a backup of the catalog store on the demo
database, using the user ID DBA and the password
sql:
dbbackup -y -x -c 'uid=DBA;pwd=sql;eng=iqdemo;dbn=iqdemo.db;links=tcpip{port=2638}' -d '/mydir'
- Using the SQLCONNECT environment variable settings if any
command line values are missing. SAP 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 Reference: Building Blocks, Tables, and Procedures > File
Locations and Installation Settings > Environment Variables.
- 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 the
Utility Guide.