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

Examples

• The following command displays the column separator:

SQL> show colsep

COLSEP " "

SQL> set colsep *

SQL> show colsep

COLSEP "*"

SHOW ERRORCODE command

The show errorcode command is an alias for the show lasterror command. For more

information, see “SHOW LASTERROR command” (page 104).

Syntax

SHOW ERRORCODE

Examples

The following command displays the error returned from the execution of the last SQL statement :

SQL> show errorcode

ERRORCODE 29481

SHOW FETCHSIZE command

The show fetchsize command displays the fetch size value for the current RMXCI session.

Syntax

SHOW FETCHSIZE

Considerations

You must enter the command in one line.

Examples

The following commands display the fetch size of the current RMXCI session, sets the fetch size to

a new value, and then displays 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.

102 RMXCI commands