APAR status
Closed as program error.
Error description
When the ODBC Connector stage is used to pass the LOBs either as inline data or by reference, the following issues are observed. 1. When the key column in the table and in the columns property is set to be a column of type decimal data type, the following error is thrown while running the job. Message: ODBC_Connector_CARS2_ROD,0: ?? (IIS-CONN-ODBC-000004; ODBC function {0} reported: SQLSTATE = HY000: Native Error Code = 921: Msg = [IBM(DataDirect OEM)][ODBC Oracle Wire Protocol driver][Oracle]ORA-00921: unexpected end of SQL command; CC_OdbcInputStream; open; CC_OdbcInputStream.cpp; 118) 2. When the LOB columns have NULL data in some records, the following error is thrown and the job aborts. Unable to determine data size for field <FieldName>, which this driver requires for data streaming operations"
Local fix
Problem summary
**************************************************************** USERS AFFECTED: Users using the LOB functionality in the ODBC Connector. **************************************************************** PROBLEM DESCRIPTION: When the ODBC Connector stage is used to pass the LOBs either asinline data or by reference, the following issues are observed. 1. When the key column in the table and in the columns property is set to be a column of type decimal data type, the following error is thrown while running the job. Message: ODBC_Connector_CARS2_ROD,0: ?? (IIS-CONN-ODBC-000004; ODBC function {0} reported: SQLSTATE = HY000: Native Error CodeDirect OEM)][ODBC Oracle Wire Protocol driver][Oracle]ORA-00921: unexpected end of SQL command; CC_OdbcInputStream; open; CC_OdbcInputStream.cpp; 118) 2. When the LOB columns have NULL data in some records, the following error is thrown and the job aborts. Unable to determine data size for field <FieldName>, which this driver requires for data streaming operations" **************************************************************** RECOMMENDATION: Apply the APAR. The fix has been included in the IS 8.1 FP1. Apply the FixPack1 for IS 8.1. ****************************************************************
Problem conclusion
Modified the code to handle the LOB references when the key column is of Decimal datatype. Also, improved the Null handling for LOBs in the code.
Temporary fix
Comments
APAR Information
APAR number
JR33276
Reported component name
WIS DATASTAGE
Reported component ID
5724Q36DS
Reported release
810
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2009-06-08
Closed date
2009-06-29
Last modified date
2009-12-19
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
R810 PSN
UP
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSVSEF","label":"IBM InfoSphere DataStage"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
19 December 2009