SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
R-12
RESET DEFINE Command
These words are reserved for the report writer. You should not use these words as
user-defined names if your site uses the report writer component of SQLCI:
RESET DEFINE Command
RESET DEFINE is an SQLCI command that restores one or more DEFINE attributes in
the working attribute set to their initial settings. (RESET DEFINE is similar to the TACL
command ADD DEFINE.)
attr
is a DEFINE attribute whose value is to be reset to its initial value. For a list of
DEFINE attributes, see DEFINEs
on page D-27.
*
resets the DEFINE class to MAP and establishes a working attribute set that
consists of the FILE attribute set to its initial value (which is no value).
Considerations—RESET DEFINE

For a description of the working attribute set, see SET DEFINE Command on
page S-32.

If an error occurs when you enter a RESET DEFINE command, the command
does not change the working attribute set.

Attributes are reset in the order you specify them.
CHECK FROM LIKE SELECT
CLOSE SET
COMMIT GROUP MAX SMALLINT
COUNT MIN SOME
CURRENT HAVING SUM
CURRENT_TIMESTAMP NOT SKIP
IF PAGE SPACE
LINE_NUMBER PAGE_NUMBER TAB
NEED REPORT
RESET DEFINE { attr [ , attr ] ... } ;
{ * }
Table R-5. Reserved Words (page2of2)