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

Examples
This command shows the last error in the current session:
SQL>select * from emp;
*** ERROR[4082]Object NEO.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 NCI session. The default is zero, which means that all rows
are returned.
Syntax
SHOW LIST_COUNT
Considerations
• You must enter the command on one line. The command does not require an SQL terminator.
• You can execute this command only in SQL mode.
• If the SET TIMING command is set to ON, the elapsed time information is displayed.
Examples
• This 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
• This 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 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 markup option:
134 NCI Commands