NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
R-18
RESET PREPARED Command
RESET PREPARED Command
RESET PREPARED is an SQLCI command that resets prepared commands. Resetting a
prepared command is equivalent to deleting it. If you have prepared the maximum of 20
commands, you can reset a command you no longer need to use in order to prepare
another command.
command-name
is the name you specified when you prepared the command.
*
resets all prepared commands.
Examples—RESET PREPARED
•
The following command resets a prepared command named EMPIN:
>> RESET PREPARED EMPIN;
RESET REPORT Command
RESET REPORT is an SQLCI report writer command that resets stored report
formatting commands (at the select-in-progress prompt, S>) or resets the most recent
SELECT command and stored report formatting commands (at the standard SQLCI
prompt, >>).
RESET PREPARED { command-name [ ,command-name] ... } ;
{ * }
{ report-cmd [ , report-cmd] ... }
RESET REPORT { * } ;
{ SELECT }
report-cmd is:
{ BREAK [ ( column [, column ] ... ) ] }
{ BREAK FOOTING [ ( column [, column ] ... ) ] }
{ BREAK TITLE [ ( column [, column ] ... ) ] }
{ DETAIL }
{ NAME [ ( alias [, alias ] ... ) ] }
{ [ PAGE ] FOOTING }
{ [ PAGE ] TITLE }
{ REPORT FOOTING }
{ REPORT TITLE }
{ SUBTOTAL [ ( column [, column ] ... ) ] }
{ TOTAL [ ( column [, column ] ... ) ] }