MX Release 3.1 (H06.23+, J06.12+)

Considerations

• You must enter the command in one line.

• The set colsep command has no effect if the markup is set to HTML, XML, or CSV.

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 FETCHSIZE command 85