Neoview Script Guide (R2.2)

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 57).
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 Neoview Script interface 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 139).
OFF
specifies that the elapsed time not be displayed after each SQL statement executes. OFF is
the default.
Considerations
In the Neoview Script interface, 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 58).
SHOW COLSEP Command
The SHOW COLSEP command displays the value of the column separator for the current Neoview
Script session.
Syntax
SHOW COLSEP
SET TIMING Command 119