SQL/MX Report Writer Guide

Using MXCI and the Report Writer
HP NonStop SQL/MX Report Writer Guide—527194-002
2-7
Canceling a SELECT Command
Canceling a SELECT Command
To stop listing rows and cancel a SELECT command, enter the CANCEL command at
the S> prompt:
S> CANCEL;
If you accidentally cancel the SELECT command, you can execute it again. For more
information, see Executing a Command Repeatedly
on page 2-13.
Defining Options for Line Folding
Line folding occurs when the information in a print list does not fit within the defined
margins. In this case, the information is folded to (continued on) the next line.
The LOGICAL_FOLDING layout option controls how information is folded for the
default detail line only. Settings for the LOGICAL_FOLDING option are:
If the information fits within the margins, LOGICAL_FOLDING has no effect.
Figure 2-2. Listing Rows
ON A single item is never folded to the next line. This is the default setting.
OFF An item is folded to the next line if it does not fit within the margins.
>> SELECT * From DEPT
+> ORDER BY DEPTNUM ;
Select Rows
MANAGER RPTDEPT LOCATION
S> LIST NEXT 2
S> LIST FIRST 1
MANAGER
RPTDEPT
DEPTNAME
FINANCE
PERSONNEL
INVENTORY
SHIPPING
MARKETING
DEPTNAME
DEPTNUM
DEPTNUM
1000
1500
2000
2500
3000
23
213
32
234
29
9000
1000
9000
2000
9000
List next
two rows
List first
row again
CHICAGO
CHICAGO
LOS ANGELES
PHOENIX
NEW YORK
1000
FINANCE
23 9000
LOCATION
CHICAGO
S>
VST0203.vsd
+> LIST FIRST 3 ;