zOs/SQL/HAERDIQ

   DELETE FROM PLAN_TABLE
    WHERE QUERYNO = 123
   ;
   SELECT CURRENT TIMESTAMP FROM SYSIBM.SYSDUMMY1;
   EXPLAIN PLAN
   SET QUERYNO = 123  FOR
        SELECT *
          FROM OA1A.TWM005A1
         WHERE D$GUEA     <=   '2006-12-15-12.38.27.000001'
           AND D$GUEB     >=   '2006-12-15-12.38.27.000001'
           AND CSTAT    BETWEEN 'A' AND 'A'
           AND CDEFAULT BETWEEN X'00' AND X'FF'
           AND CTYP        =    'VEVA'
           AND NDEP        =    '0835000000185000' || ''
           AND TWMD1       =    '412'
   ;
   SELECT * FROM  PLAN_VIEW5 WHERE QUERYNO = 123
-- SELECT CURRENT TIMESTAMP FROM SYSIBM.SYSDUMMY1
   ;
X- EXPLAIN PLAN
-- SET QUERYNO = 123 FOR
        SELECT *
          FROM OA1A.TWM005A1
         WHERE D$GUEA     <=   '2006-12-15-12.38.27.000001'
           AND D$GUEB     >=   '2006-12-15-12.38.27.000001'
           AND CSTAT    BETWEEN 'A' AND 'A'
           AND CDEFAULT BETWEEN X'00' AND X'FF'
           AND CTYP        =    'VEVA'
           AND NDEP        =    ''
           AND TWMD1       =    '412'
   ;
-- SELECT * FROM  PLAN_VIEW5 WHERE QUERYNO = 123
   SELECT CURRENT TIMESTAMP FROM SYSIBM.SYSDUMMY1
   ;
-- EXPLAIN PLAN
-- SET QUERYNO = 123 FOR
        SELECT *
          FROM OA1A.TWM005A1
         WHERE D$GUEA     <=   '2006-12-15-12.38.27.000001'
           AND D$GUEB     >=   '2006-12-15-12.38.27.000001'
           AND CSTAT    BETWEEN 'A' AND 'A'
           AND CDEFAULT BETWEEN X'00' AND X'FF'
           AND CTYP        =    'VEVA'
           AND NBU         =    '0005'
           AND NDEP        =    ''
           AND TWMD1       =    ''
   ;
   SELECT CURRENT TIMESTAMP FROM SYSIBM.SYSDUMMY1
-- SELECT * FROM  PLAN_VIEW5 WHERE QUERYNO = 123
   ;