Oracle DB to IBM DB2 for i-series(ODBC)

[nabeelaslam1994]

Hi Support Team,

I am trying to copy data from Oracle DB to DB2 database and getting an error. DB2 target endpoint is setup as ODBC. I have a successful connection when tested. I had also changed the Provider Syntax to 'DB2' under advanced settings. 

ERROR:

execute statement failed
RetCode: SQL_ERROR SqlState: HYC00 NativeError: 30058 Message: [IBM][System i Access ODBC Driver]Driver not capable.
Failed (retcode -1) to execute statement: 'INSERT INTO X (X,X,X,X,X) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)'

Second Error:

Failed to send an end of data record (ID=16002) for table with ID '1'.

[Dana_Baldwin · Accepted solution]

Hi @nabeelaslam1994 

Please work with our Professional Services team a configuring an ODBC target endpoint has special considerations.

From our User Guide:

The ODBC target endpoint can be used to access targets that are not included in Qlik Replicate’s extensive Support Matrix. However, unless enabled through Professional Services and approved by your Account Manager, the ODBC target endpoint should not be used. Additionally, the ODBC target endpoint should not be used to access any targets already listed in the Support Matrix.

Using ODBC to connect to a target #Using ODBC to connect to a target | Qlik Replicate Help

Please contact your account manager to arrange for help from Professional Services.

Thanks,

Dana

[john_wang · Accepted solution]

Hello @nabeelaslam1994 ,

Not very sure about Qlik Replicate version and the IBM ODBC Client version. I'm guessing you are running a lower version of ODBC Driver. Please try version 7.1.27 ( aka IBM iAccess v13.26.27). If you still face problems, please enable PS service, as Dana mentioned.

Good luck,

John.