IBM Support

JR58446: MULTIPLE SYBASE ASE BULKLOAD PROBLEMS WITH THE ODBC DRIVER.

Subscribe

You can track all active APARs for this component.

 

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
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback