Hi, I am getting this below the error. Can You Please help me guys..
we need to update records in DB2 database table on AS/400 using Business Objects Data Integrator 11.7. Data integrator Designer version is 11.7.3 Drivers installed are iSeries ACCESS ODBC Driver 11.0.2,CLIENT ACCESS ODBC DRIVER 11.0.2
We are able to do the update for a single record, but while doing Bulk Update, we are getting below error message, Can anyone help on this.
DBS-070401: ODBC DATA SOURCE Error Message for Operation : <[IBM][iSeries Access ODBC Driver]Driver not capable.> RUN-051005: Execution of for target failed. Possible causes: (1) Error in the SQL syntax; (2) Database connection is broken; (3) Database related errors such as transaction log is full, etc.; (4) The user defined in the datastore has insufficient privileges to execute the SQL. If the error is for preload or postload operation, or if it is for regular load operation and load triggers are defined, please check the SQL. Otherwise, for (3) and (4), please contact your local DBA.