SQL/MX Remote Conversational Interface (RMXCI) Guide for SQL/MX Release 3.1 (H06.23+, J06.12+)

IDLETIMEOUT 0 min(s) [Never Expires]
Elapsed time:00:00:00:078
For more information, see “Setting and showing the idletimeout value for the session” (page 35).
SHOW LASTERROR command
The show lasterror command displays the error returned from the execution of the last SQL
statement. The command returns zero, if the last SQL statement was successfully run.
Syntax
SHOW LASTERROR
Considerations
• You must enter the command in one line.
• If the set timing command is set to on, the elapsed time information appears.
Examples
The following command shows the last error in the current RMXCI session:
SQL>select * from emp;
*** ERROR[4082]Object CAT.SCH.EMP does not exist or is inaccessible.
SQL>show lasterror
LASTERROR 4082
SHOW LIST_COUNT command
The show list_count command displays the maximum number of rows to be returned by SELECT
statements in the current RMXCI session. The default is zero, which means that all rows are returned.
Syntax
SHOW LIST_COUNT
Considerations
• You must enter the command in one line.
• If the set timing command is set to on, the elapsed time information appears.
Examples
• The following command shows that SELECT statements return all rows in the current session:
SQL>show list_count
LISTCOUNT 0 [All Rows]
Elapsed time:00:00:00:078
• The following command shows that the maximum number of rows to be displayed by SELECT
statements in the session is five:
SQL>set list_count 5
SQL>show list_count
LISTCOUNT 5
Elapsed time:00:00:00:078
104 RMXCI commands