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

Examples
• The following command specifies the separator as |(pipe):
SQL>set colsep |
SQL>show colsep
COLSEP "|"
SQL>select * from employee;
EMPNUM|EMPNAME |REGNUM|BRANCHNUM|JOB
------|--------------|------|---------|--------
1|ROGER GREEN | 99| 1|MANAGER
23|JERRY HOWARD | 2| 1|MANAGER
29|JACK RAYMOND | 1| 1|MANAGER
32|THOMAS RUDLOFF| 5| 3|MANAGER
39|KLAUS SAFFERT | 5| 2|MANAGER
--- 5 row(s) selected.
SET FETCHSIZE command
The set fetchsize command allows you to change the default fetch size used by NonStop
JDBC Type 4 Driver. Setting the value to zero sets the fetch size to the default value used in NonStop
JDBC Type 4 Driver.
Syntax
SET FETCHSIZE value
value
is an integer representing the fetch size as a number of rows. Zero represents the default value
of fetch size set in NonStop JDBC Type 4 Driver.
Considerations
You must enter the command in one line.
Examples
The following command sets the fetch size to one:
SQL>set fetchsize 1
SQL>show fetchsize
FETCHSIZE 1
SQL>select * from stream(t1);
C1 C2 C3
------- ------- -------
TEST1 TEST2 TEST3
AAA BBB CCC
SET HISTOPT command
The set histopt command sets the history option and controls how commands are added to
the history buffer. By default, commands within a script file are not added to history. If the history
option is set to ALL, all the commands in the script file are added to the history buffer. If no options
are specified, DEFAULT is used.
108 RMXCI commands