APAR status
Closed as user error.
Error description
Generated sql in Oracle Connector stage giving error - connector detected an unexpected character
Local fix
Problem summary
Problem conclusion
Temporary fix
Comments
User was treating the Oracle Connector "Table name" property as if it were the OCI Plugin "FROM clause" property. For Oracle Connector, you must specify a single table name for the "Table name" property. Generated SQL cannot be used in Oracle Connector to select columns from multiple tables.
APAR Information
APAR number
JR39842
Reported component name
WIS DATASTAGE
Reported component ID
5724Q36DS
Reported release
850
Status
CLOSED USE
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2011-06-14
Closed date
2011-06-14
Last modified date
2011-06-14
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Applicable component levels
[{"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.5","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
14 June 2011