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

Examples
This command specifies the separator as a |(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 fetchsize used by JDBC. Setting
the value to 0 sets the fetchsize to the default value used in JDBC.
Syntax
SET FETCHSIZE value
value
is an integer representing the fetch size as a number of rows. Zero (0) represents the default
value of fetch size set in JDBC.
Considerations
You must enter the command on one line.
The command does not require an SQL terminator.
The command is supported only in SQL mode.
Examples
This command sets the fetchsize to 1:
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.
SET FETCHSIZE Command 119