A fix is available
APAR status
Closed as program error.
Error description
Trailing semi-colon problem in user defined sql in ODBC stage. This was not a problem previous to 7.5.1a
Local fix
Problem summary
**************************************************************** USERS AFFECTED: Server job aborts when multiple user-defined SQL statements are used in the ODBC stage **************************************************************** PROBLEM DESCRIPTION: Server ODBC stage separates multiple user-defined SQL statements causing the user-defined SQL not to be handled as a single statement. **************************************************************** RECOMMENDATION: This change is included in 8.0.1 Fix Pack 2. ****************************************************************
Problem conclusion
Added a workaround for oracle database to keep trailing semicolon in user-defined sql. To enable this, just set user defined env var ODBCKeepSemicolon=1.
Temporary fix
Comments
APAR Information
APAR number
JR30597
Reported component name
WIS DATASTAGE
Reported component ID
5724Q36DS
Reported release
801
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2008-09-26
Closed date
2009-06-30
Last modified date
2011-07-13
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 PSY
UP
[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSVSEF","label":"InfoSphere DataStage"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.0.1"}]
Document Information
Modified date:
07 October 2021