PK95171: variable type ?Date? returns incorrect value

APAR status

• Closed as program error.

Error description

• Environment: Windows
  
  Product name: IBM? Rational? Business Developer
  
  Program Version    :  7.1.0.3
  additional:DB2 v8.2 z/OS
  Description.
  Using the variable type ?Date? the wrong value is within the app
  licable date field after a read of the date from DB2.
  
  The application returns an correct value from a database concern
  ing the date type column ie:
  The column  DT_DEBUT is a date type and retrieving a row by usin
  g a get statement and a call to a stored procedure.
  
  The value of the column  DT_DEBUT is 01.01.1900 and when definin
  g an sqlRecord using the date type for this column and running t
  he application it returns 31/12/1899.
  
  The same value is returned for the get statement or the stored p
  rocedure.
  When defining this column as char(10)it returns the correct valu
  e of  01.01.1900 .
  
  
  Example steps to reproduce:
  a) retrieve an SQLRecord from DB2 Z/OS to get a variable of date
   type ie
  10 DT_DEBUT date  {column='DT_DEBUT'};
  b) Set the defaultFormatDate to dd/MM/yyyy
  c) Run program and receive a value of 31/12/99.
  
  This occurs when running with EGL debugger or when generated to
  Java.
  

Local fix

Problem summary

• This problem can happen in the EGL debugger and generated
  Java programs. When running in certain time zones, some
  dates are incorrectly assigned to EGL date variables. For
  example the date Jan 1 1900 in the time zone for Paris will
  become Dec 31 1899.
  

Problem conclusion

• We can't fix the problem in ICU4J, but we found a way to
  work around it.
  

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:

Fix information

• Fixed component name

  RATL BUS DEV

• Fixed component ID

  5724S5000

Applicable component levels

• R751 PSN

     UP