APAR status
Closed as Vendor Solution.
Error description
Multiple problems were observed with Sybase ASE ODBC Driver whenever EnableBulkLoad=1 is set in the ODBC DSN. These are problems in the DataDirect Sybase ASE ODBC Driver. Following are the problems: 1. EnableBulkLoad jobs abort with "Syntax error or access violation" error whenever tablename is fully qualified. With just tablename, the issue is no longer seen. 2. Sybase ASE ODBC Driver returns incorrect precision with SQLDescribeCol API for varchar fields 3. Sybase ASE ODBC Driver jobs with EnableBulkLoad=1 set abort when only integer field is present in the schema 4. Sybase ASE ODBC Driver job crashes whenever EnableBulkLoad=1 is set in some environments Additional keywords: datastage jobs
Local fix
Problem summary
Problem conclusion
Temporary fix
Comments
All these problems are resolved with the Sybase ASE ODBC Driver version starting with: 07.16.0207 (B0364, U0243) or later. Also all the driver sets branded on or after 18th Sep 2017 will contain these fixes in them.
APAR Information
APAR number
JR58446
Reported component name
WIS DATASTAGE
Reported component ID
5724Q36DS
Reported release
B50
Status
CLOSED ISV
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2017-09-15
Closed date
2017-09-18
Last modified date
2017-09-19
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":"11.5","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
19 September 2017