SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
R-16
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 to
prepare another command.
command-name
is the name you specified when you prepared the command.
*
resets all prepared commands.
Example—RESET PREPARED

This example 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 ] ... ) ] }