IBM Support

JR57630: ODBC CONNECTOR METADATA IMPORT SETS INCORRECT DECIMAL DIGITS FORALL TYPES ON ZLINUX PLATFORM

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • When metadata is imported using ODBC Connector on zLinux
    platform, it imports incorrect decimal digits. The decimal
    digits of the first valid field are carried forward until next
    valid field, irrespective of the type of the field in between.
    The ODBC Driver on zLinux is behaving differently when compared
    to other platforms. In order to overcome this, we had to reset
    the decimal digits variable to zero for every SQLFetch after
    calling SQLColumns API.
    

Local fix

Problem summary

  • When ODBC Connector is used to import the table metadata in
    zLinux platform, the imported metadata is having incorrect
    fractional digits. The valid fractional digit is carried forward
    until the next valid fractional digits, irrespective of the
    types in between.
    

Problem conclusion

  • This is a change in behaviour in the ODBC Driver on the zLinux
    platform. We have made a code change in the ODBC Connector to
    overcome this problem.
    

Temporary fix

  • Keep all fields which are having fractional digits at the end of
    the table.
    

Comments

APAR Information

  • APAR number

    JR57630

  • Reported component name

    IS GOVCATLOG

  • Reported component ID

    5724Q36GC

  • Reported release

    B50

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2017-03-22

  • Closed date

    2017-03-31

  • Last modified date

    2017-03-31

  • 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

    IS GOVCATLOG

  • Fixed component ID

    5724Q36GC

Applicable component levels

  • RB30 PSY

       UP

  • RB31 PSY

       UP

  • RB50 PSY

       UP

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSZJPZ","label":"IBM InfoSphere Information Server"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
02 June 2020