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

Syntax
SHOW ERRORCODE
Examples
This command displays the error of the last SQL statement that was executed:
SQL> SHOW ERRORCODE
ERRORCODE 29481
SHOW FETCHSIZE Command
The SHOW FETCHSIZE command displays the fetch size value for the current NCI session.
Syntax
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 re-display 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:
136 NCI Commands