Connecting to a Database from Interactive SQL on UNIX

The following procedure shows how to connect to a running database from Interactive SQL.

1. Start the server and the database by typing at a system command prompt:

   start_iq dbname

2. Start Interactive SQL by typing at a system command prompt:

   dbisql -c "uid=userID;pwd=password" -host hostname -port portnum -n servername dbfilename.db

   The -c parameter specifies connection parameters.

   For example, to connect to the demo database on remote host fiona, you enter:

   dbisql -c "uid=DBA;pwd=sql" -host fiona -port 1870 -n fiona_iqdemo $IQDIR15/demo/iqdemo.db

   You do not need to specify the host and port if you are connecting to a database on your local machine.