Now type ISQL (or the name of your EXEC for ISQL) as follows:
isql
Press ENTER.
ISQL responds with a display similar to the one shown in Figure 6.
Figure 6. Initial ISQL Display
+--------------------------------------------------------------------------------+ | Ready; T=0.01/0.03 13:41:49 | | isql | | ARI0659I Line-edit symbols reset: | | LINEND=# LINEDEL=OFF CHARDEL=OFF | | ESCAPE=OFF TABCHAR=OFF | | ARI0662I EMSG function value reset to ON. | | ARI0320I The default server name is SAMPLEDB. | | ARI7716I User SQLUSER1 connected to server SAMPLEDB. | | ARI7399I The ISQL default profile values are in effect. | | ARI7079I ISQL initialization complete. | | ARI7080A Please enter an ISQL command or an SQL statement | +--------------------------------------------------------------------------------+
If your system default is not set for the full-screen environment, you can set it by typing SET FULLSCREEN ON on a CMS command line. Full-screen CMS uses several preset PF keys and displays the current PF key settings in the bottom portion of the display. Before you start ISQL, the PF settings reflect those for the CMS environment. For example, keying PF12 lets you type a command on the command line. After you start ISQL, the PF key settings displayed change to the ISQL settings, and the display is similar to the one shown in Figure 7.
Figure 7. Initial ISQL Display with Full-Screen CMS
+--------------------------------------------------------------------------------+ | Fullscreen CMS Columns 1 - 79 of 81 | | | | Ready; T=0.01/0.03 13:41:49 | | isql | | ARI0659I Line-edit symbols reset: | | LINEND=# LINEDEL=OFF CHARDEL=OFF | | ESCAPE=OFF TABCHAR=OFF | | ARI0662I EMSG function value reset to ON. | | ARI0320I The default server name is SAMPLEDB. | | ARI7716I User SQLUSER1 connected to server SAMPLEDB. | | ARI7399I The ISQL default profile values are in effect. | | ARI7079I ISQL initialization complete. | | ARI7080A Please enter an ISQL command or an SQL statement | | | | | | | | | | | | | | | | | | PF1=HELP 2=START 3= 4= 5=RECALL 6= | | PF7= 8= 9=HOLD 10= 11= 12=RETRIEVE | | | +--------------------------------------------------------------------------------+
All commands you type appear in the input area near the bottom of the display. All data returned by ISQL appears on a different display; when you exit from such a display, a display similar to the one shown in Figure 7 is returned.
If you want to temporarily suspend the full-screen option, see the VM/ESA: CMS Command Reference manual, for information on the SET FULLSCREEN command.