SQL/MP Report Writer Guide

Using SQLCI and the Report Writer
HP NonStop SQL/MP Report Writer Guide—527213-001
2-5
Setting Up Your Session Environment
0. For more information on the summary of the options, see Report Writer Components
on page 1-10.
Listing Rows of a Report
You retrieve rows of data by using the SELECT command. You can specify the number
of rows to be displayed or printed by setting the LIST_COUNT session option and by
using the LIST command. By default, LIST_COUNT is set to ALL when you begin your
SQLCI session. Unless you want all retrieved rows displayed, you should set the
LIST_COUNT value before you enter a SELECT command. For example, the following
command specifies listing 3 rows before a pause:
>> SET LIST_COUNT 3;
After the first three rows appear, SQLCI displays the select-in-progress prompt (S>).
As shown in Figure 2-3, you can use the LIST command to display rows following the
last displayed row or to return to the first retrieved row before displaying more rows.
You can abbreviate LIST (L), FIRST (F), NEXT (N), and ALL (A). Pressing RETURN at
the S> prompt is the same as entering LIST NEXT n (specifying n as the current
LIST_COUNT value).
The number you specify for the value of n relates to rows. For example, if the
information from a row appears on two output lines and you specify LIST NEXT 3, six
Figure 2-3. Example of Listing Rows
>> SELECT * From PERSNL. 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