38.5.12 #SET DISPLAY (outputs the retrieval results)

Function

Specifies whether to output the retrieval results.

The initial value is ON (output the retrieval results).

Format

#SET DISPLAY {ON|OFF};

ON: Outputs the retrieval results.

OFF: Does not output the retrieval results.

Example

This example displays SQL statement execution time, excluding the time required for processing and outputting the retrieval results.

adbsql -u ADBUSER01 -p '#HelloHADB_01'                       ...1
#SET EXECTIME REPORT ON;                                     ...2
#SET DISPLAY OFF;                                            ...3
SELECT * FROM "T1";                                          ...4
KFAA96404-I 100000000 rows were selected.
KFAA96415-I SQL processing time (Fetch) : 18.863501 sec.     ...5
#EXIT;                                                       ...6

Explanation:

1. Starts the adbsql command with the -u and -p options specified.

2. Specifies ON (output SQL statement execution time) in #SET EXECTIME REPORT.

3. Specifies OFF in #SET DISPLAY (do not output the retrieval results).

4. Executes the SQL statement.

5. Displays the SQL statement execution time, excluding the time required for processing and outputting the retrieval results.

6. Terminates the adbsql command.

Notes

If you specify the -s option when starting the adbsql command, you cannot execute #SET DISPLAY.

To Page Top