Examples of Invoking isql

Go Up to Invoking isql

• Suppose createdb.sql contains DDL statements to create a database. To execute the statements, enter:

isql -input createdb.sql

• The following example starts an interactive connection to a remote database. The remote server, jupiter, accepts the specified user and password combination with the privileges assigned to the STAFF role:

isql -user sales -password mycode -role 'staff''jupiter:/usr/customer.ib'

• The next example starts an interactive session but does not attach to a database. isql commands are displayed, and query results print column headers every 30 lines:

isql -echo -page 30