PM22658: Wrong date value added to database when sqlDataCode=384 is specified on the column in the SQL Record

APAR status

• Closed as program error.

Error description

• Rational Business Developer V7.5.1.5:
  
  Date formats are inserted into the database incorrectly.   When
  the date value is set to '2009-12-24', it is added as
  '0012-09-20'.
  
  The following is an example of EGL code that causes this
  problem:
  
  Record  emp type sqlRecord {tableNames = [emptble]}
    10 startDate char(10) {column='startDate', isSqlNullable=yes,
                           sqlDataCode=384};
  END
  
  function main()
    emp emp;
    emp.startDate = "2009-12-24";
    try
      add emp;
    end
  end
  
  Note the following:
  - This problem did not occur using the V7.5.1.4 and earlier
    support.
  
  - This problem does not occur if the sqlDataCode=384 property is
    removed from the emp SQL record.
  
  - This problem occurs using the EGL Debugger and running
    generated Java and COBOL programs.
  
  - For the generated Java and the EGL Debugger, setting the
    defaultDateFormat build descriptor option resolves this issue.
    For the example provided, setting
  
      defaultDateFormat="yyyy-MM-dd"
  
    resolves the issue.
  
  - This problem is applicable to time and timestamp columns also.
    Setting defaultTimeFormat and defaultTimeStampFormat resolves
    this for generated Java programs and in the EGL Debugger.
  
  - For the generated COBOL, a fix is needed to resolve this for
    date, time and timestamp columns.
  
  - An option is needed to not add the sqlDataCode for date, time
    and timestamp columns since removing this value resolves
    this issue.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The logic for sqldatacode for date/time/timestamp was
  causing problems when the user did not set up the proper
  date format information for the environment. The EGL team
  has decided to back out the logic for cobolgen, for these
  sqldatacodes and will revisit the logic sometime in the
  future.
  

Problem conclusion

• Software updated. Fixtest available.
  

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

  RBD EGL FOR COB

• Fixed component ID

  5724S5001

Applicable component levels

• R751 PSN

     UP