PH69903: DERIVED COLUMN EXPRESSION FUNCTION %TODATETIME DOES NOT EVALUATE CORRECTLY.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When using the %TODATETIME function in a derived column or
  filtering expression with *MDY format specifier, the value
  returned is always "1901-01-01".
  

Local fix

• No local fix is available.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of InfoSphere CDC for z/OS             *
  ****************************************************************
  * PROBLEM DESCRIPTION: using %TODATETIME with *MDY causes it   *
  *                      to always evaluate to 1901-01-01 due    *
  *                      to a bug in the parsing code which      *
  *                      detects *MDY as *JUL and then fails     *
  *                      the length check for *JUL format and    *
  *                      defaults to 1901-01-01                  *
  ****************************************************************
  caused by a misplaced -1 in the if statement that determines
  if the format is *JUL , always evaluating to true. Which then
  fails the length check when the data was meant for *MDY format.
  Defaulting the resulting values to 1901-01-01 regardless of
  input.
  

Problem conclusion

• fixed the check for the *JUL format so that *MDY can work
  correctly in %TODATETIME.
  

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:

  UO06796

Modules/Macros

• CHCMIEXD
  

Fix information

• Fixed component name

  INFO SRVR CDC Z

• Fixed component ID

  5655U7600

Applicable component levels

• RA21 PSY UO06796

     UP26/03/02 P F602

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.