PM74691: Retrieve SQL returns error message SQL type UNKNOWN for type LONG VARCHAR

Rational Business Developer Fix Pack 5 (8.0.1.5) for 8.0.1
Rational Business Developer 9.0
Rational Business Developer Fix Pack (8.5.1.1) for 8.5.1
Rational Business Developer Fix Pack 2 (8.5.1.2) for 8.5.1

APAR status

• Closed as program error.

Error description

• Headline:
  Retrieve SQL result in error message 'SQL type UNKNOWN for type
  LONG VARCHAR'
  
  APAR Error Description:
  Abstract: Attempts to use the feature 'Retrieve SQL' from EGL
  editor with IBM Rational Business Developer result
  
  
  Problem: When you have column in DB2 defined as a LONG VARCHAR,
  you get the following error message while trying to perform a
  SQL Retrieve :
  IWN.VAL.4584.i 1/1 Column ZONECLE was not retrieved because it
  is defined with SQL type ?UNKNOWN?, which is not supported.
  
  Local fix:
  Not known workaround
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  In RBD 8.0.1.3, when you have column in DB2 defined as a
  LONG VARCHAR, you get the a runtime error while trying to
  perform a SQL Retrieve.
  

Problem conclusion

• In RBD 8.0.1.5 and after, SQL retrieve works correctly for
  column of LONG VARCHAR type.
  

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

  RATL BUS DEV

• Fixed component ID

  5724S5000

Applicable component levels

• R850 PSN

     UP