PI05569: ABEND04E DSNXGDT2:M206 WHEN A TIMESTAMP WITH TIME ZONE VARIABLE IS COMPARED TO TIMESTAMP IN A NATIVE SQL PROCEDURE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• ABEND04E DSNXGDT2:M206 WHEN A TIMESTAMP WITH TIME ZONE VARIABLE
  IS COMPARED TO TIMESTAMP IN A NATIVE SQL PROCEDURE
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All DB2 10 for z/OS users who use TIMESTAMP  *
  *                 WITH TIME ZONE variables in comparison with  *
  *                 TIMESTAMP data in a native SQL procedure or  *
  *                 compiled SQL scalar function                 *
  ****************************************************************
  * PROBLEM DESCRIPTION: ABEND04E DSNXGDT2 M206 may occur when a *
  *                      TIMESTAMP WITH TIME ZONE variable is    *
  *                      compared to TIMESTAMP data in a native  *
  *                      SQL procedure or compiled SQL scalar    *
  *                      function.                               *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Here is an example to show the failing case.
  
   =========
    EXAMPLE
   =========
  
   CREATE TABLE MYTABLE1 (C1 TIMESTAMP);
  
   CREATE PROCEDURE MYPROC
   BEGIN
  
    DECLARE V1 TIMESTAMP WITH TIME ZONE;
    DECLARE V2 INTEGER;
  
    SET V1 = '2008-09-15-01.01.02.123456-8:00';
  
    SELECT 2001 INTO V2 FROM MYTABLE1 WHERE C1 = V1;
  
   END
  
  ABEND04E DSNXGDT2 M206 may occur when the above SELECT statement
  is processed.
  

Problem conclusion

• DB2 code has been modified to handle the aforementioned problem
  correctly.
  
  Additional keywords: SQLTIMESTAMPTZ SQLTIMESTAMP SQLNATIVESQLPL
                       SQLHOSTVAR SQLWHERE
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  UI13396

Modules/Macros

• DSNXOBFB
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RA10 PSY UI13396

     UP13/12/25 P F312

Fix is available

• Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.