APAR status
Closed as program error.
Error description
Product: OLEDB STAGE Platform: INTEL Release: 8.0.1 (del prodotto acquistato) OS: Windows OS Rel: 2000/2003 When no information in the fields "BEFORE STATEMENT" or "AFTER STATEMENT" or "WHERE CLAUSE" or "OTHER CLAUSE" it's not possible to compile the job with this stage (workaround is to insert a blank in the fields Before, after or other; and a "dummy condition" in the field where)
Local fix
Please make sure there is nothing in the Before and After tabs. Currently there is a space in both the BEFORE/AFTER tab boxes - click in the box and remove any spaces so as to ensure it is completely empty. If you enter a space in the Before/After/Other tabs it will work. This fix is included in 8.0.1 fix pack 3
Problem summary
**************************************************************** USERS AFFECTED: Users of MSOLE Plugin **************************************************************** PROBLEM DESCRIPTION: A job containing a MSOLE Plugin fails to compile. **************************************************************** RECOMMENDATION: The default in the MSOLE GUI is that the BEFORE, AFTER, WHERE and OTHER parts of an SQL statement are required. The resolution was to make those parts optional. ****************************************************************
Problem conclusion
The work-around is to add a space to the user defined SQL for BEFORE, AFTER, WHERE and OTHER SQL statements. The fix is to apply the patch for this APAR.
Temporary fix
Comments
APAR Information
APAR number
JR31752
Reported component name
WIS QUALITYSTAG
Reported component ID
5724Q36QS
Reported release
801
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2009-01-22
Closed date
2009-02-13
Last modified date
2010-12-10
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
CLIENT
Fix information
Fixed component name
WIS QUALITYSTAG
Fixed component ID
5724Q36QS
Applicable component levels
R801 PSY
UP
R802 PSY
UP
R810 PSY
UP
[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSVSBF","label":"InfoSphere QualityStage"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.0.1","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
10 December 2010