SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013

C-1

CANCEL Command

CANCEL is an SQLCI report writer command that cancels the current SELECT and

returns to the standard SQLCI prompt. Selected rows and current report formatting

commands become unavailable, except through the FC command.

Consideration—CANCEL



CANCEL does not delete reports. You can still display or save a report after using

CANCEL:

Example—CANCEL

This example lists the first five rows of SELECT output and cancels the SELECT

statement:

>> SET LIST_COUNT 5;

>> SELECT * FROM SALES.ODETAIL;

ORDERNUM PARTNUM UNIT_PRICE QTY_ORDERED

-------- ------- --------------------- -----------

100124 4103 25000.00 2

100210 244 3500.00 2

100210 2001 1100.00 3

100210 2403 620.00 3

100210 5100 150.00 6

S> CANCEL;

CANCEL ;

SHOW REPORT *; Displays a report

SAVE REPORT * TO file; Saves a report