JR34700: SYBASE OC STAGE DOESNT SUPPORT UNSIGNED INTEGER AND UNSIGNED TINYINT

Download Fix Pack 2 for InfoSphere Information Server Version 8.1

APAR status

• Closed as program error.

Error description

• Sybase OC stage didn't support unsigned integer and unsigned
  tinyint datatypes
  

Local fix

• This fix is included in 8.0.1 fix pack 3
  

Problem summary

• ****************************************************************
  USERS AFFECTED:
  Information Server 8.0.1 on Sun fixpack1 .Sybase IQ v 12.7
  ****************************************************************
  PROBLEM DESCRIPTION:
  Sybase_OC stage error Field type must be either an int8,
  int16, uint16, or int32 in order to call
  setOutputFieldAsInteger() for field '0' in outputDS '0'.
  ****************************************************************
  

Problem conclusion

• The following functionalities are supported now:
  
  1. INTEGER (-2147483648 and 2147483647)
  2. SMALLINT (-32768 and 32767)
  3. TINYINT (0 to 255) and we have to mention unsigned in DS.
  
  Patch can be delivered to customer.
  

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

• R801 PSY

     UP