SQL text and host variables

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

SQL text and host variables

On this page