SQL/MX Remote Conversational Interface (RMXCI) Guide for SQL/MX Release 3.2 (H06.25+, J06.14+)

Considerations
• You must enter the command in one line.
• To reset the number of displayed rows, enter the following command:
set list_count 0
Examples
• The following 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>
• The following 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
RMXCI.
Syntax
SET MARKUP [RAW|HTML|XML|CSV|COLSEP]
SET MARKUP command 111