Fixes are available
APAR status
Closed as program error.
Error description
In the ODBC connector, if a job is configured with some SQL statements in the After SQL property, these statements are executed even in the case where the job failed when any of the player processes failed. Ideally, when the main SQL statement generates any failure and the job has to abort, there is no reason why the After SQL statements should be executed.
Local fix
N/A
Problem summary
In the ODBC connector, if a job is configured with some SQL statements in the After SQL property, these statements are executed even in the case where the job failed when any of the player processes failed. Ideally, when the main SQL statement generates any failure and the job has to abort, there is no reason why the After SQL statements should be executed.
Problem conclusion
Do not execute After SQL statements when the job is failing. This change has been made under the scope of an environment variable CC_ODBC_SKIP_AFTERSQL_ON_FAILURE to insure that there is no change in behavior for any of the jobs designed this behavior of executing After SQL on job failure The environment variable (CC_ODBC_SKIP_AFTERSQL_ON_FAILURE) needs to be set to 1 in the job / project environment
Temporary fix
There is no known temporary fix
Comments
APAR Information
APAR number
JR46439
Reported component name
WIS DATASTAGE
Reported component ID
5724Q36DS
Reported release
870
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2013-04-24
Closed date
2013-05-10
Last modified date
2013-05-10
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
R850 PSY
UP
R870 PSY
UP
R910 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.7","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
11 October 2021