The examples below show how to use Interactive SQL (dbisql) at the system command prompt level.
The following command, entered at a system prompt, runs the command file mycom.sql against the current default server, using the user ID dba and the password sql. If there is an error in the command file, the process terminates.
dbisql -c "uid=DBA;pwd=sql" -onerror exit mycom.sql
The following command, when entered on a single line at a command prompt, adds a user to the current default database:
dbisql -c "uid=DBA;pwd=sql" grant connect to joe identified by passwd
