I run task replicate from SQL Server Source to ODBC (IBM Db2 iSeries) has error can not create table Exception

[DuongNguyen]

how to fix it?

[john_wang · Accepted solution]

Hello @DuongNguyen ,

This is duplicate to article: SQL Server Source to ODBC(IBM DB2 for iSeries) Target has error: Fail to get schema for table. We have solved the issue already, in short:

Replicate supports DB2i and DB2 LUW target via ODBC generic endpoint. The syntax should be set to GenericWithoutSchema  for DB2i target.

Regards,

John.

[DuongNguyen · Accepted solution]

@john_wang thank you so much!

[john_wang · Accepted solution]

Hello @DuongNguyen ,

It's a glad to work with you. Thank you so much for your great support!

Best,

John.