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

2:17:17 PM SQL>set time off
SQL>
For more information, see “Customizing the Standard Prompt” (page 63).
SET TIMING Command
The SET TIMING command causes the elapsed time to be displayed after each SQL statement
executes. This command does not cause the elapsed time of NCI commands to be displayed. By
default, the elapsed time is off.
Syntax
SET TIMING { ON | OFF }
ON
specifies the elapsed time be displayed after each SQL statement executes. For a list of these
statements, see Appendix B (page 155).
OFF
specifies that the elapsed time not be displayed after each SQL statement executes. OFF is
the default.
Considerations
You must enter the command on one line. The command does not require an SQL terminator.
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 64).
SHOW ACCESS Command
The SHOW ACCESS command displays the current status of access information to memory
dump files.
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.
SET TIMING Command 131