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

SHOW FETCHSIZE Command
The SHOW FETCHSIZE command displays the fetch size value for the current NCI session.
Syntax
SHOW FETCHSIZE
Considerations
• You must enter the command on one line.
• This command is supported in all modes.
Examples
These commands display the fetch size in the current NCI session, set the fetch size to a new
value, and then redisplay the fetch size:
SQL>show fetchsize
FETCHSIZE 0 [Default]
SQL>SET fetchsize 1
SQL>SHOW fetchsize
FETCHSIZE 1
SHOW HISTOPT Command
The SHOW HISTOPT command displays the value that has been set for the history option.
Syntax
SHOW HISTOPT
Considerations
• You must enter the command on one line.
• If the SET TIMING command is set to ON, the elapsed time information is displayed.
Examples
This command displays the value set for the history option:
SQL>show histopt
HISTOPT DEFAULT [No expansion of script files]
SQL>set histopt all
SQL>show histopt
HISTOPT ALL
128 NCI Commands