JR60016: UNABLE TO READ FROM SYBASE IQ WHEN THE SAME TABLE NAME EXISTS FOR TWO DIFFERENT SCHEMAS

Download the mod pack for IBM InfoSphere Information Server 11.7.1.0 In-Place Upgrade

APAR status

• Closed as program error.

Error description

• Sybase read job reads incorrect data from Sybase IQ when the
  same table name exists for two different schemas.
  

Local fix

Problem summary

• Error description
  Unable to read from Sybase IQ when the same table name exists
  for two different schemas.?
  Problem summary
  *
  ****************************************************************
  * USERS AFFECTED:
  * Users using Sybase Enterprise stage to read from Sybase IQ
  *
  *
  ****************************************************************
  * PROBLEM DESCRIPTION:
         When Sybase Enterprise stage is used to read from the
  Sybase IQ, incorrect data is read when table with same name
  exists in two different schemas.
  ****************************************************************
  

Problem conclusion

• Code fix:  Modified the code to get the owner for the table and
  then read from the table.
  

Temporary fix

Comments

APAR Information

• 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

  WIS DATASTAGE

• Fixed component ID

  5724Q36DS

Applicable component levels

• RB31 PSY

     UP

• RB50 PSY

     UP

• RB70 PSY

     UP