IBM Support

IC90131: 5.3.1 ODBC MAPPING ISSUE: WHEN IMPORTING NULL VALUE IN A DATE FIELD, DATE IS DISPLAYED AS 19691231

Subscribe

You can track all active APARs for this component.

 

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