A fix is available
APAR status
Closed as program error.
Error description
DataStage job will fail with a fatal error when trying to access a Sybase table with a column name longer than 30 characters. This is reproducible using the Sybase 15_0 open client, and either a Sybase ASE 15 server or Sybase IQ 12.7 server, all of which support column names longer than 30 characters. The DataStage jobs fail both using the SybaseOC plug-in stage as well as the Sybase Enterprise stage.
Local fix
This fix is included in 8.0.1 fixpack 3
Problem summary
Syabase OC stage not allowing column names longer than 30 characters even though the Sybase 15 Open Client and Sybase database support this feature. The Sybase Enterprise stage has same problem.
Problem conclusion
Sybase OC and Sybase EE libraries are built with OCS-15_0 libraries to support long column names
Temporary fix
Comments
APAR Information
APAR number
JR32459
Reported component name
WIS DATASTAGE
Reported component ID
5724Q36DS
Reported release
801
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2009-03-23
Closed date
2012-04-20
Last modified date
2012-04-20
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 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.0.1","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
12 October 2021