A fix is available
APAR status
Closed as program error.
Error description
Customer receives warning message from DB2 causing their job to fail. This is with DB2 on zLinux.
Local fix
Problem summary
**************************************************************** USERS AFFECTED: Server ODBC stage fails with SQLExecDirect error. **************************************************************** PROBLEM DESCRIPTION: When the update action of the server ODBC stage is set to "Clear the table, then insert rows", job aborts with error: DSD.BCIOpenW call to function SQLExecDirect failed. The database used is DB2 on z/OS. **************************************************************** RECOMMENDATION: Apply patch JR35667. ****************************************************************
Problem conclusion
Patch fixed the issue in DSEgnine by allowing the process to continue when SQLNumResultCols returns SQL_SUCCESS_WITH_INFO. To suppress the message when SQLExecDirect returns SQL_SUCCESS_WITH_INFO, just add user-defined environment variable DSODBC_NO_DB2_DELETE_WARNIGNS and set its value to 1.
Temporary fix
Comments
APAR Information
APAR number
JR35667
Reported component name
WIS DATASTAGE
Reported component ID
5724Q36DS
Reported release
810
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2010-02-16
Closed date
2010-03-22
Last modified date
2010-03-22
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
SERVER
Fix information
Fixed component name
WIS DATASTAGE
Fixed component ID
5724Q36DS
Applicable component levels
R801 PSN
UP
R810 PSY
UP
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSVSEF","label":"InfoSphere DataStage"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.1","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
11 October 2021