APAR status
Closed as program error.
Error description
DataStage Patch e129322_linux_DS752 for SINGLEROW option with Oracle 8 partitioning does not work with other options. The application team states: 1) The patch works fine when SINGLEROW is the only option used. 2) The patch does not work when multiple options are used. The control file generated by DataStage has incorrect syntax. When you remove the SINGLEROW option from the parameter level the process works and that is how they determined the two options are creating a conflict in the control file syntactically.
Local fix
This fix is included in 8.0.1 fix pack 3
Problem summary
**************************************************************** USERS AFFECTED: 7.5.2 and above. **************************************************************** PROBLEM DESCRIPTION: The SQL*Loader control file option SINGLEROW option does not work when loading a table partition. You get a syntax error if you try to use this option that way. **************************************************************** RECOMMENDATION: Apply patch. This change is included in 8.1 Fix Pack 1. ****************************************************************
Problem conclusion
A limitation of SQL*Loader. We check the condition in the program and ignore the hint to inser thet SINGLEROW option in the control file.
Temporary fix
Comments
APAR Information
APAR number
JR30428
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-08
Closed date
2008-09-17
Last modified date
2010-12-09
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
R801 PSN
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.0.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
09 December 2010