NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
S-53
SHOW REPORT Command
SHOW REPORT Command
SHOW REPORT is an SQLCI report writer command that displays the current SELECT
statement and the current report formatting commands.
* displays the SELECT and all report formatting commands.
For information about a specific command, see the entry for that command. (The
command listed as BREAK refers to the BREAK ON command.)
Examples—SHOW REPORT
•
The following command displays the current report title and page footer:
>> SHOW REPORT TITLE, PAGE FOOTING;
REPORT TITLE "ORDER DETAILS" CENTER;
PAGE FOOTING TAB 50, "Page ", PAGE_NUMBER AS I3;
SHOW REPORT { { command } [, command ] ... } ;
{ * }
command is:
{ BREAK }
{ BREAK FOOTING }
{ BREAK TITLE }
{ DETAIL }
{ NAME }
{ PAGE FOOTING }
{ PAGE TITLE }
{ REPORT FOOTING }
{ REPORT TITLE }
{ SELECT }
{ SUBTOTAL }
{ TOTAL }