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

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

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



Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

Sterling Gentran:Server for Microsoft Windows

Software version:

531

Reference #:

IC90131

Modified date:

2013-04-05

Translate my page

Machine Translation

Content navigation