HP NEOVIEW 544530-001 Manual do Utilizador descarregar pdf (Página 113)

Starting with the R2.1 release, the default is a 24–hour military style display. The additional

argument of 12h allows the time to be displayed in a 12–hour AM/PM style.

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 53).

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 133).

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 54).

SHOW COLSEP Command

The SHOW COLSEP command displays the value of the column separator for the current Neoview

Script session.

SET TIMING Command 113

1 2 ... 108 109 110 111 112 113 114 115 116 117 118 ... 141 142

Sem comentários

HP NEOVIEW 544530-001 Manual do Utilizador Página 113