SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
R-13
Example—RESET DEFINE

When you reset the CLASS attribute, you set the DEFINE class to MAP and
establish a working attribute set consisting of the FILE attribute (set to its initial
value).

If you reset an attribute that does not belong to the current class, an error message
appears.
Example—RESET DEFINE
This example shows the way RESET DEFINE changes the working attribute set.
Initially, the working attribute set contains attributes for CLASS CATALOG. RESET
DEFINE resets the SUBVOL attribute value. Because the SUBVOL attribute is required
(there is no default value), the attribute is set to no value.
>> SHOW DEFINE *;
CLASS CATALOG
SUBVOL \SYS1.$VOL1.PERSNL
>> RESET DEFINE SUBVOL;
>> SHOW DEFINE *;
CLASS CATALOG
SUBVOL ??
Current attribute set is incomplete
RESET LAYOUT Command
RESET LAYOUT is an SQLCI report writer command that resets layout options to their
default settings. Layout options affect the way a report appears on screen or on the
printed page.
The layout options and their default settings are:
* resets all options to default settings.
For more information, see entries for specific options.
RESET { [ LAYOUT ] option [, option ] ... } ;
{ LAYOUT * }
CENTER_REPORT OFF
LEFT_MARGIN 0
LINE_SPACING 1
LOGICAL_FOLDING ON
PAGE_COUNT ALL
PAGE_LENGTH ALL (terminal); 60 (other devices)
RIGHT_MARGIN Output device width
SPACE 2
WINDOW TAB 1 (all columns)