Space announcement This space provides the same content as before, but the organization of the home page has changed. The content is now organized based on logical branches instead of legacy book titles. We hope that the new structure will help you quickly find the content that you need.

SQL text and host variables


Related topic

Exception-Advisor-reference

Both summary and detail reports display SQL text. The following example shows some SQL text from the exception report:

Example
SQL text:                                      
UPDATE   AFDQA.QATBL01                         
  SET      DATETIME_EFF = CURRENT TIMESTAMP    
  WHERE    COL_A = 13

 The following example shows a detail report with host variables, SQL text, and objects:

Example
Host variables:                                                                                                          
# 1 (INTEGER)          38                                                                                                
                                                                                                                        
Accessed objects:                                                                                                       
Object name    (Type)        BP Name  Getpages    Getpage time   %elap   SyncIOs  SyncIO time     %elap
=====================        =======  ========    ============   =====   =======  ===========     ====
AFDQA.QATBL01     (T)        BP0         23263        0.001641    0.0          1     6.074652     88.1
                                                                                                                        
SQL text:                                                                                                                
SELECT   *                                                                                                               
  INTO     :H, :H, :H, :H, :H, :H                                                                                        
  FROM     AFDQA.QATBL01                                                                                                 
  WHERE    COL_A = :H

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*