Connecting to a Database from Interactive SQL on UNIX

You do not need to specify the host and port for a database on your local machine.

1. At a system command prompt, start the server and the database:

   start_iq dbname

2. Start Interactive SQL:

   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, enter:

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