Neoview Command Interface (NCI) Guide (R2.4)

Considerations
• You must enter the command on one line. The command does not require an SQL terminator.
• You can execute this command only in SQL mode.
• To reset the number of displayed rows, enter this command:
SET LIST_COUNT 0
Examples
• This command specifies that the number of rows to be displayed by SELECT statements is
five:
SQL>set list_count 5
SQL>select empnum, first_name, last_name
from persnl.employee
order by empnum;
EMPNUM FIRST_NAME LAST_NAME
------ --------------- --------------------
1 ROGER GREEN
23 JERRY HOWARD
29 JANE RAYMOND
32 THOMAS RUDLOFF
39 KLAUS SAFFERT
--- 5 row(s) selected. LIST_COUNT was reached.
SQL>
• This command resets the number of displayed rows to all rows:
SQL>set list_count 0
SQL>select empnum, first_name, last_name
+>from persnl.employee
+>order by empnum;
EMPNUM FIRST_NAME LAST_NAME
------ --------------- --------------------
1 ROGER GREEN
23 JERRY HOWARD
29 JANE RAYMOND
32 THOMAS RUDLOFF
39 KLAUS SAFFERT
43 PAUL WINTER
65 RACHEL MCKAY
...
995 Walt Farley
--- 62 row(s) selected.
SQL>
SET MARKUP Command
The SET MARKUP command sets the markup format and controls how results are displayed by
NCI.
Syntax
SET MARKUP [RAW|HTML|XML|CSV|COLSEP]
122 NCI Commands