JR47165: BIGINT, -1234567890123456789 IS TRUNCATED BY MSOLEDB PLUGIN.

InfoSphere Information Server, Version 11.3 for Microsoft Windows
InfoSphere Information Server, Version 11.3 for AIX
InfoSphere Information Server, Version 11.3 for Linux
IBM InfoSphere Information Server Enterprise Edition V11.3 for Windows

APAR status

• Closed as program error.

Error description

• BigInt, '-1234567890123456789' can be inserted and read from the
  database, but it is being truncated like '-123456789012345678'
  by the MSOLEDB Plugin stage.
  

Local fix

• Use a different data type like varchar
  

Problem summary

• MSOLEDB Plugin was allocating 19 bytes for BigInt numbers. This
  is correct, except that this does not account for potential
  negative sign.
  

Problem conclusion

• This patch increases the buffer length to 20 to account for
  potential negative sign when using very large negative
  numbers.
  

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

• R910 PSY

     UP