HP 3000 Manuals

ALLBASE/SQL Performance and Monitoring Guidelines

SET ECHO 

Echoes commands to standard output

Scope 

SQLMON Only

SQLMON Syntax 

SET E[CHO] [ON ]
           [OFF]
Parameters 

ON                      Causes your input to appear on standard output.

OFF                     Does not cause your input to appear on standard
                        output.  The default value.

Description 

   *   When ECHO is set to ON, SQLMON displays on standard output all of
       the commands you enter.

   *   SET ECHO is primarily used in batch jobs.

   *   See "Creating Batch Reports" in the chapter "Getting Started with
       SQLMON."

Examples 

After you enter the following command, SQLMON commands you enter appear
on standard output:

     SQLMONITOR  OVERVIEW => SET ECHO ON 

You can also use SET ECHO in a batch file to display the commands in the
file as they execute.  In the example, the Static screen is copied to an
output file named Report1:

     SET ECHO ON
     SET DBENVIRONMENT PartsDBE
     SET CYCLE 1
     SET OUTPUT Report1
     STATIC
     EXIT

f you omit the last parameter, SQLMON prompts for it, as follows:

     SQLMONITOR  OVERVIEW => SET ECHO 

     ON/OFF: ON 

MPE/iX 5.0 Documentation