SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013

R-19

RESET SESSION Command

RESET SESSION is an SQLCI session command that resets SQLCI session options

to default settings.

The session options and their default settings are:

* resets all options to their default settings.

For more information, see SET SESSION Command on page S-39.

Example—RESET SESSION

This example resets the LIST_COUNT and WARNINGS options:

>> RESET LIST_COUNT, WARNINGS;

RESET STYLE Command

RESET STYLE is an SQLCI report writer command that resets style options to their

default settings. Style options affect the appearance of specific report items, such as

underlines, headings, and date and time formats.

The style options and their default settings are:

RESET [ SESSION ] { option [, option ] ... } ;

{ * }

AUTOWORK ON

BREAK_KEY ON

DISPLAY_ERROR ALL

ERROR_ABORT OFF

ERROR_TEXT DETAIL

LIST_COUNT ALL

MANDATORY_REPORT OFF

STATISTICS OFF

WARNINGS ON

WRAP ON

RESET { [ STYLE ] option [, option ] ... } ;

{ STYLE * }

DATE_FORMAT M2/D2/Y2

DECIMAL_POINT .

HEADINGS ON