Interactive SQL Connection Parameters

When no database is connected, SAP Sybase IQ displays the Connect window to request connection parameters. Information you enter in the Connect window is not preserved between sessions.

The connection parameters you specify in the Connect window are dependent on the number of databases running on the database server. To connect to a single database, you only need to complete the User ID and Password fields if the server was started on the local machine with IQTMP16 environment variable set. If there are multiple databases running on the database server, you must specify additional connection parameters such as the server or database name.

Enter connection parameters in the Connect window using one of these methods:

Using the Connect Assistant
Manually

Note: You can bypass the Connect window by supplying the connection parameters on the command line with the -c option.

If the Connect window or an error message about missing information appears, you may need to enter the -host and -port or other missing information in the Advanced tab. If your database is on a remote server, enter the -host and -port parameters on separate lines, as in:

-host fiona
-port 1870

Supplying Connection Parameters Using the Connect Assistant
The Connect window has a Connect Assistant wizard to help you connect to a database. To display or hide the Connect Assistant, click the arrow in the top right corner of the window.
Supplying Connection Parameters Manually
Connect to a database using the Identification, Database, Network, and Advanced Options tabs on the Connect window.
Connect Window Tools
Click Tools at the bottom of the Connect window to access options.

Parent topic: dbisql Interactive SQL Utility

Starting Interactive SQL from the Windows Start Menu

Related reference

Interactive SQL Command Line Options