Using Other Programs within ISQL

Using the System Editor

You can invoke any editor on your system from ISQL. Use the ISQL SET command with the EDITOR option to define the editor you want to use. For example:

   isql=> SET EDITOR TDP.PUB.SYS;

   isql=> EDIT;

For complete information on using the SET command, refer to chapter 4, "ISQL Commands."

Using System Commands and Programs

You can execute operating system commands by using the SYSTEM command. You can specify the SYSTEM command or the system interrupt character (:) before an operating system command and return immediately to ISQL as follows:

   isql=> SYSTEM LISTF @.SQL;



   FILENAME



   DAILY     MONTHLY     YEARLY

Only MPE/iX commands that can be executed when you press the BREAK key can be entered.

You can also temporarily leave the ISQL environment to execute operating system commands, then return to ISQL by entering RESUME. For example:

   isql=> :

   : LISTF @.SQL;



   FILENAME



   DAILY     MONTHLY     YEARLY



   : RESUME

Using SQLUtil

SQLUtil is a program that lets you perform maintenance tasks on a DBEnvironment. SQLUtil commands cannot be issued directly from ISQL. You must first invoke SQLUtil from ISQL by using the SQLUTIL command, as shown here:

   isql=> SQLUTIL;

The SQLUtil banner and prompt (>>) are displayed. Then you can execute SQLUtil commands until you enter an EXIT or QUIT command. For complete information on using SQLUtil, refer to the "DBA Tasks and Tools" chapter of the ALLBASE/SQL Database Administration Guide.

Using SQLGEN

SQLGEN is a program that allows you to re-create a given DBEnvironment.

SQLGEN commands cannot be issued directly from ISQL. You must first invoke SQLGEN from ISQL by using the SQLGEN command as follows:

  isql=> SQLGEN;

The SQLGEN banner and prompt (>>) are displayed. You can then execute SQLGEN commands until you enter an EXIT or QUIT command. For complete information on using SQLGEN, refer to the "DBA Tasks and Tools" chapter of the ALLBASE/SQL Database Administration Guide.