Fixes are available
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 number
PM74691
Reported component name
RATL BUS DEV
Reported component ID
5724S5000
Reported release
850
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2012-10-10
Closed date
2013-03-11
Last modified date
2013-03-11
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
[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSMQ79","label":"Rational Business Developer"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.5","Edition":"","Line of Business":{"code":"LOB35","label":"Mainframe SW"}}]
Document Information
Modified date:
11 March 2013