SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
S-53
SHOW SESSION Command
SHOW SESSION Command
SHOW SESSION is an SQLCI command that displays the values of the current
session options.
* displays all session options.
For an explanation of each session option, see SET SESSION Command on
page S-39.
Example—SHOW SESSION
This example displays the current values of all options:
>> SHOW SESSION *;
-----------------------------
Current SESSION Option Values
-----------------------------
AUTOWORK ON
BREAK_KEY OFF
DISPLAY_ERROR MAIN
ERROR_ABORT OFF
ERROR_TEXT DETAIL
LIST_COUNT 10
MANDATORY_REPORT ON
STATISTICS OFF
WARNINGS ON
WRAP OFF
SHOW [ SESSION ] { option [, option ] ... } ;
{ * }
option is:
{ AUTOWORK }
{ BREAK_KEY }
{ DISPLAY_ERROR }
{ ERROR_ABORT }
{ ERROR_TEXT }
{ LIST_COUNT }
{ MANDATORY_REPORT }
{ STATISTICS }
{ WARNINGS }
{ WRAP }