SQL/MX Remote Conversational Interface (RMXCI) Guide for SQL/MX Release 3.2 (H06.25+, J06.14+)

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
SHOW MARKUP command
The show markup command displays the value set for the markup option.
Syntax
SHOW MARKUP
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 displays the value set for the markup option:
SQL>show markup
MARKUP RAW
Elapsed time:00:00:00:078
SHOW PARAM command
The show param command displays the parameters that are set in the current RMXCI session.
SHOW LIST_COUNT command 127