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 number
PM22658
Reported component name
RBD EGL FOR COB
Reported component ID
5724S5001
Reported release
751
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2010-09-16
Closed date
2010-10-13
Last modified date
2010-10-13
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
[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSMQ79","label":"Rational Business Developer"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.5.1","Edition":"","Line of Business":{"code":"LOB35","label":"Mainframe SW"}}]
Document Information
Modified date:
13 October 2010