The following procedure shows how to connect to a running database from dbisql.
Connecting to a database from Interactive SQL
on UNIX
Start the server and the database by typing at a system command prompt:
start_iq dbname
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. See “Connection parameters” for more about 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.
