HP 3000 Manuals HP 3000 Manuals
SET OUTPUT
Saves SQLMON screen images in a file
Scope
SQLMON Only
SQLMON Syntax
SET OUTP[UT] [SystemFileName]
[OFF ]
Parameters
SystemFileName Echoes the screens that SQLMON displays on
standard output to SystemFileName.
OFF Does not echo screens to a file. The default
value.
Description
* If you issue a SET OUTPUT command with a filename, and if the file
does not exist, SQLMON creates it.
* If you issue a SET OUTPUT command with a filename, and if the file
exists, SQLMON asks you if you want to overwrite it.
* SQLMON appends information to the file until you issue SET OUTPUT
OFF or terminate the SQLMON session.
* For more information, see the "Examples" section or the section
"Creating Batch Reports" in the chapter "Getting Started with
SQLMON."
Examples
If you issue the commands
SQLMONITOR OVERVIEW => SET OUTPUT Myfile
SQLMONITOR OVERVIEW => OVERVIEW
SQLMONITOR OVERVIEW => OVERVIEW SESSION
SQLMONITOR OVERVIEW => SET OUTPUT OFF
SQLMON creates Myfile and adds images of both the Overview and Overview
Session screens to the file.
If you then issue the commands
SQLMONITOR OVERVIEW => SET OUTPUT Myfile
System Filename already exists. Overwrite? yes
SQLMONITOR OVERVIEW => LOCK
SQLMONITOR OVERVIEW => LOCK OBJECT
SQLMONITOR OVERVIEW => SET OUTPUT OFF
SQLMON overwrites Myfile and then appends images of the Lock and Lock
Object screens to the file.
To prevent accidental data loss, SQLMON prompts you before it overwrites
the file, as in
SQLMONITOR OVERVIEW => SET OUTPUT Myfile
SystemFileName already exists. Overwrite? ([NO],YES) no
SystemFileName not overwritten.
If you omit the last parameter, SQLMON prompts for it, as in
SQLMONITOR OVERVIEW => SET OUTPUT
SystemFileName <or OFF>: OFF