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

This query ends with the new terminator, go:
SQL>select * from persnl.employee go
• To reset the SQL terminator to the default, enter this command:
SQL>set sqlterminator ;
For more information, see “Setting and Showing the SQL Terminator” (page 62).
SET STATISTICS Command
The SET STATISTICS command automatically retrieves the statistics information for a query
being executed. The results returned are the same as would have been returned if the GET
STATISTICS command was executed. The default is OFF which means the statistics information
is not automatically printed for any queries.
Syntax
SET STATISTICS {ON | OFF}
Considerations
• You must enter the command on one line.
• You can execute this command in SQL mode only.
Examples
This command shows the default output format as PERTABLE:
SQL>set statistics on
SQL>select * from job;
JOBCODE JOBDESC
------- ------------------
100 MANAGER
1234
450 PROGRAMMER
900 SECRETARY
300 SALESREP
500 ACCOUNTANT
400 SYSTEM ANALYST
250 ASSEMBLER
420 ENGINEER
600 ADMINISTRATOR
200 PRODUCTION SUPV
--- 11 row(s) selected.
Start Time 2007/09/18 21:45:34.082329
End Time 2007/09/18 21:45:34.300265
Elapsed Time 00:00:00.217936
Compile Time 00:00:00.002423
Execution Time 00:00:00.218750
Table Name Records Records Disk Message Message Lock LockDisk Process
Accessed Used I/Os Count Bytes Escl WaitBusy Time
NEO.TOI.JOB 2 2 0 4 15232 0 0 363
SQL>
For more information on the STATISTICS command, see the Neoview SQL Reference Manual.
SET TIME Command
The SET TIME command causes the local time of the client workstation to be displayed as part
of the interface prompt. By default, the local time is not displayed in the interface prompt.
SET STATISTICS Command 131