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

Examples
• This command causes the local time to be displayed in the SQL prompt:
SQL>set time on
14:17:17 SQL>
• This command causes the local time to be displayed in 12–hour AM/PM style in the SQL
prompt:
SQL>set time on 12h
2:17:17 PM SQL>
• This command turns off the local time in the SQL prompt:
2:17:17 PM SQL>set time off
SQL>
For more information, see “Customizing the Standard Prompt” (page 47).
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.
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.
• The elapsed time value includes compile and execution time plus any network I/O time,
client-side processing time, and any WMS-queue hold time.
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 48).
124 NCI Commands