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

Example
The first command changes the role of the NCI session to ROLE.MGR, and the second command
logs on the user as that role:
SQL>set connectopt role ROLE.MGR
SQL>connect [e-mail], mydsn
Password:
For more information, see the “CONNECT Command” (page 78).
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
110 NCI Commands