JR30214: INCLUSION OF NEW DATATYPE IN SQL SERVER 2005 VARCHAR(MAX)

APAR status

• Closed as program error.

Error description

• Inclusion of datatype Varchar(max) in sqlserver 2005 so PX can
  handle it.
  

Local fix

• This fix is included in 8.0.1 fix pack 3
  

Problem summary

• ****************************************************************
  USERS AFFECTED:
  All platforms . ODBC EE stage using SQL_LONGVARCHAR type
  ****************************************************************
  PROBLEM DESCRIPTION:
  SQL_LONGVARCHAR data type was not supported in ODBC EE stage due
  to unavailability of support for the same in PX Framework.
  ****************************************************************
  RECOMMENDATION:
  Install patch_30214
  ****************************************************************
  

Problem conclusion

• Added support for SQL_LONGVARCHAR data type for limited length
  upto 2 MB
  

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:

Modules/Macros

• ODBC
  

Fix information

• Fixed component name

  WIS DATASTAGE

• Fixed component ID

  5724Q36DS

Applicable component levels

• R752 PSN

     UP