7. Using Monitoring and Tracing Tools : Trace Utilities : SET Options for Tracing Queries : Example: Turn Query Display On Using ING_SET
 
Share this page                  
Example: Turn Query Display On Using ING_SET
The following command turns query display on:
Windows:
SET ING_SET=set printqry
UNIX:
C Shell:
setenv ING_SET "set printqry"
Bourne Shell:
ING_SET = "set printqry"
export ING_SET
VMS:
DEFINE ING_SET "SET PRINTQRY"
As an example, assume that QBF is started up. The following is displayed:
Query Buffer:
set Autocommit on
Query Parameters:

Query Buffer:
select cap_value, cap_capability from iidbcapabilities
Query Parameters:

Query Buffer:
select user_name, dba_name from iidbconstants
Query Parameters: