IBM Support

JR39781: ON 64-BIT IS, READING A SAS NUMBER FIELD AS INTEGER GIVES THE RESULT NULL EVEN THOUGH THE VALUE IS NOT NULL IN SAS.

 

APAR status

  • Closed as program error.

Error description

  • On Information Server running on 64 bit platforms, while reading
    a SAS table number field as integer using the SAS operator gives
    the result as null even though the value is not null in SAS.
    This works fine on the 32 bit versions such as DS 7.5 and IS
    8.0.1 or on IS 8.1/IS 8.5 running on Linux 32 bit.
    

Local fix

Problem summary

  • On Information Server running on 64 bit platforms, reading a SAS
    table number field as integer gives the result null even though
    the value is not null in SAS.
    

Problem conclusion

  • The comparision between the source and the target values is
    giving incorrect results because of mismatch in the data types.
    The same has been corrected.
    

Temporary fix

  • Change the Integer type to Numeric in the job while reading the
    SAS datasets.
    

Comments

APAR Information

  • APAR number

    JR39781

  • Reported component name

    DSTAGE PCK FOR

  • Reported component ID

    5724Q5700

  • Reported release

    810

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2011-06-07

  • Closed date

    2011-06-24

  • Last modified date

    2011-11-23

  • 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

    DSTAGE PCK FOR

  • Fixed component ID

    5724Q5700

Applicable component levels

  • R810 PSY

       UP

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

Document Information

Modified date:
14 October 2021