APAR status
Closed as program error.
Error description
Issue introduced in 5.3.1. When using ODBC Mapping during import of a date field with Null the date is brought into the Output side of the map as 19691231 instead of Null not populating outbound side. Other problems experienced: Compile and Translation is slower than previous versions.
Local fix
STRRTC - 366280 AW / AW Circumvention: None
Problem summary
5.3.1 ODBC mapping issues: (1) When importing a document (ODBC to positional), a NULL value from an ODBC date field resulted in 19691231 in the document. (2) When doing inbound processing (EDI to ODBC), if the interchange has multiple datetime values to store in a single ODBC row, the last datetime value is used for any datetime column.
Problem conclusion
(1) When retrieving values from ODBC database (datetimes, strings or numbers) added checks to see if the value is NULL. If so, the field did not retrieve a value. (2) Instead of re-using a single datetime variable, added a datetime array to use for ODBC inserts.
Temporary fix
Comments
APAR Information
APAR number
IC90131
Reported component name
STR GENTRAN MS
Reported component ID
5725D0903
Reported release
531
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2013-02-11
Closed date
2013-04-05
Last modified date
2013-04-05
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
STR GENTRAN MS
Fixed component ID
5725D0903
Applicable component levels
R531 PSY
UP
[{"Business Unit":{"code":"BU055","label":"Cognitive Applications"},"Product":{"code":"SS6V3G","label":"Sterling Gentran:Server for Microsoft Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"531","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
05 April 2013