HPlogo ALLBASE/SQL Performance and Monitoring Guidelines: HP 9000 Computer Systems > Chapter 9 SQLMON Command Reference

SET ECHO
» 

Technical documentation

Complete book in PDF
» Feedback

 » Table of Contents

 » Index

spacerspacerspacer
spacer
spacer
  		 
 

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

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

   SQLMONITOR OVERVIEW => SET ECHO



   ON/OFF: ON


SET DISPLAYSAMPLES
  		 


SET LOCKFILTER  
Feedback to webmaster