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

Examples
• This command displays the elapsed time of SQL statements:
SQL>set timing on
• This command turns off the elapsed time:
SQL>set timing off
For more information, see “Displaying the Elapsed Time” (page 62).
SHOW ACCESS Command
The SHOW ACCESS command displays the current status of access information to memory
dump files.
Syntax
Syntax
------
SHOW ACCESS TO DUMPFILES
Considerations
• You must enter the command on one line. The command does not require an SQL terminator.
Example
This SHOW ACCESS command displays the current status of the dumpfile.
SQL>show access to dump files
ACCESS TO DUMP FILES DENIED
-- NS operation complete.
SHOW ACTIVITYCOUNT Command
The SHOW ACTIVITYCOUNT command provides an alias for SHOW RECCOUNT.
ACTIVITYCOUNT is an alias for RECCOUNT. For more information, see the “SHOW RECCOUNT
Command” (page 144).
Syntax
SHOW ACTIVITYCOUNT
Examples
This command shows the record count of the previous executed SQL statement:
SQL> SHOW ACTIVITYCOUNT
ACTIVITYCOUNT 0
SHOW ALIAS Command
The SHOW ALIAS command displays all or a set of aliases available in the current NCI session.
If a pattern is specified, all aliases matching the pattern are displayed. By default, all aliases in
the current session are displayed.
SHOW ACCESS Command 133