IBM Support

JR36823: SYBASEENTERPRISE STAGE DOES NOT RETURN DATA OF DOUBLE TYPE CORRECTLY.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • SybaseEnterprise stage does NOT return data of double type
    correctly.
    0 is returned even if actual data is like 10, 20 ,40 ... .
    
    It happens on IS81+FP1.
    

Local fix

Problem summary

  • ****************************************************************
    USERS AFFECTED:
    All platforms, jobs using Sybase EE
    ****************************************************************
    PROBLEM DESCRIPTION:
    SybaseEnterprise stage does NOT return data of double type
    correctly.
    
    ****************************************************************
    RECOMMENDATION:
    Install patch for JR36823
    ****************************************************************
    

Problem conclusion

  • Sybase EE Read Method = ASE Read, did not get data type of
    double column correctly for Sybase IQ databases when schema
    qualifier was used with table. This was resulting in the data in
    the column getting corrupted.
    Modified code to handle schema qualifier with the table.
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR36823

  • Reported component name

    WIS DATASTAGE

  • Reported component ID

    5724Q36DS

  • Reported release

    810

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2010-06-10

  • Closed date

    2010-06-21

  • Last modified date

    2011-09-08

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Modules/Macros

  • SYBASEEE
    

Fix information

  • Fixed component name

    WIS DATASTAGE

  • Fixed component ID

    5724Q36DS

Applicable component levels

  • R810 PSN

       UP

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

Document Information

Modified date:
08 September 2011