User Guide : A. Command Reference : isql Command--Start Interactive SQL Terminal Monitor
 
Share this page                  
isql Command--Start Interactive SQL Terminal Monitor
The isql command invokes the forms-based Terminal Monitor for interactive SQL (ISQL).
The isql command has the following format:
isql [SQL option flags] dbname|vnode::dbname
SQL option flags
Specify options passed to the Terminal Monitor when invoked. These include the standard flags (-uusername, -Ggroupid, and -Rroleid), and formatting and DBMS control flags. For details, see sql Command--Start the Line-based SQL Terminal Monitor.
dbname
Identifies the name of the database, and if required, the vnode.
isql Examples
This command invokes interactive forms-based SQL on the employee database on a local node:
isql employee
This command invokes interactive forms-based SQL on the employee database on the hq remote node:
isql hq::employee
This command opens empdata, displays float4 columns in G format with two decimal places and integer1 columns with three spaces:
isql -f4g12.2 -i13 empdata