Connecting from SAP Sybase IQ Utilities

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'

  1. 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.

  2. 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.

Parent topic: Ways to Connect