APAR status
Closed as program error.
Error description
When the table action is set to Truncate and user defined SQL is provided as "Truncate table <TableName>", the ODBC Connector job is failing with the following error while connecting to the DB2 Database. ODBC Info: SQLSTATE = HY000: Native Error Code = -428: Msg = [IBM(DataDirect OEM)][ODBC DB2 Wire Protocol driver][UDB DB2 for Windows, UNIX, and Linux]Unknown error: SQLCODE -428
Local fix
Use the DB2 Connector stage.
Problem summary
ODBC Connector job is failing while executing the truncate table action and connecting to DB2 Database.
Problem conclusion
Fixed code: To honour the AutoCommit Mode
Temporary fix
Comments
APAR Information
APAR number
JR44125
Reported component name
WIS DATASTAGE
Reported component ID
5724Q36DS
Reported release
870
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2012-09-18
Closed date
2012-10-12
Last modified date
2012-10-12
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
ODBCCC
Fix information
Fixed component name
WIS DATASTAGE
Fixed component ID
5724Q36DS
Applicable component levels
R870 PSY
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.7","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
12 October 2012