JR31646: PROBLEM WHEN USING VARCHAR DATATYPE WITH ODBC EE DB2: MAIN_PROGRAM: DATATYPE NOT SUPPORTED.

APAR status

• Closed as fixed if next.

Error description

• Using the ODBC EE stage with VarChar(2000) column results in the
  following error:
  "Datatype Not Supported"
  
  
  Product Name       Information Server
  Component Name     Stage runtime
  SubComp Name       ODBC EE
  Product Release    8.0.1.0
  Platform           IBM
  OS Name            AIX
  OS Release         5.3
  DB Server          DB2 UDB
  DB Release         8.1.1.128
  

Local fix

• This fix is included in 8.0.1 fixpack 3
  

Problem summary

• ****************************************************************
  USERS AFFECTED:
  ODBC EE
  ****************************************************************
  PROBLEM DESCRIPTION:
  Using the ODBC EE stage with VarChar(2000) column results in
  thefollowing error:
    "Datatype Not Supported"
  ****************************************************************
  RECOMMENDATION:
  Apply patch patch_JR31646_server_aix.tar or later date ODBC EE
  patch
  The fix has been included in the IS 8.1 FP1. Apply the FixPack1
  for IS 8.1.
  ****************************************************************
  

Problem conclusion

• The problem has been addressed by adding the support for the
  datatype varchar(2000).
  

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

Applicable component levels

• R801 PSN

     UP