https://community.qlik.com/t5/Qlik-Replicate/I-run-task-replicate-from-SQL-Server-Source-to-ODBC-IBM-Db2/m-p/2126331#M7606 <P>Hello&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/249556">@DuongNguyen</a>&nbsp;,</P> <P>This is duplicate to article:&nbsp;<SPAN><A title="SQL Server Source to ODBC(IBM DB2 for iSeries) Target has error: Fail to get schema for table" href="https://community.qlik.com/t5/Qlik-Replicate/SQL-Server-Source-to-ODBC-IBM-DB2-for-iSeries-Target-has-error/td-p/2126321" target="_blank" rel="noopener">SQL Server Source to ODBC(IBM DB2 for iSeries) Target has error: Fail to get schema for table</A>. We have solved the issue already, in short:</SPAN></P> <P><SPAN>Replicate supports DB2i and DB2 LUW target via ODBC generic endpoint. The syntax should be set to&nbsp;<FONT face="courier new,courier">GenericWithoutSchema</FONT>&nbsp; for DB2i target. </SPAN></P> <P><SPAN>Regards,</SPAN></P> <P><SPAN>John.</SPAN></P> Sun, 08 Oct 2023 05:42:14 GMT john_wang 2023-10-08T05:42:14Z https://community.qlik.com/t5/Qlik-Replicate/I-run-task-replicate-from-SQL-Server-Source-to-ODBC-IBM-Db2/m-p/2126285#M7592 <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="DuongNguyen_0-1696692710627.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/117831iD841ED4801594898/image-size/medium?v=v2&amp;px=400" role="button" title="DuongNguyen_0-1696692710627.png" alt="DuongNguyen_0-1696692710627.png" /></span></P> <P>how to fix it?</P> Sat, 07 Oct 2023 15:32:24 GMT https://community.qlik.com/t5/Qlik-Replicate/I-run-task-replicate-from-SQL-Server-Source-to-ODBC-IBM-Db2/m-p/2126285#M7592 DuongNguyen 2023-10-07T15:32:24Z https://community.qlik.com/t5/Qlik-Replicate/I-run-task-replicate-from-SQL-Server-Source-to-ODBC-IBM-Db2/m-p/2126331#M7606 <P>Hello&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/249556">@DuongNguyen</a>&nbsp;,</P> <P>This is duplicate to article:&nbsp;<SPAN><A title="SQL Server Source to ODBC(IBM DB2 for iSeries) Target has error: Fail to get schema for table" href="https://community.qlik.com/t5/Qlik-Replicate/SQL-Server-Source-to-ODBC-IBM-DB2-for-iSeries-Target-has-error/td-p/2126321" target="_blank" rel="noopener">SQL Server Source to ODBC(IBM DB2 for iSeries) Target has error: Fail to get schema for table</A>. We have solved the issue already, in short:</SPAN></P> <P><SPAN>Replicate supports DB2i and DB2 LUW target via ODBC generic endpoint. The syntax should be set to&nbsp;<FONT face="courier new,courier">GenericWithoutSchema</FONT>&nbsp; for DB2i target. </SPAN></P> <P><SPAN>Regards,</SPAN></P> <P><SPAN>John.</SPAN></P> Sun, 08 Oct 2023 05:42:14 GMT https://community.qlik.com/t5/Qlik-Replicate/I-run-task-replicate-from-SQL-Server-Source-to-ODBC-IBM-Db2/m-p/2126331#M7606 john_wang 2023-10-08T05:42:14Z https://community.qlik.com/t5/Qlik-Replicate/I-run-task-replicate-from-SQL-Server-Source-to-ODBC-IBM-Db2/m-p/2126334#M7608 <P><a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/115309">@john_wang</a>&nbsp;thank you so much!</P> Sun, 08 Oct 2023 05:43:42 GMT https://community.qlik.com/t5/Qlik-Replicate/I-run-task-replicate-from-SQL-Server-Source-to-ODBC-IBM-Db2/m-p/2126334#M7608 DuongNguyen 2023-10-08T05:43:42Z https://community.qlik.com/t5/Qlik-Replicate/I-run-task-replicate-from-SQL-Server-Source-to-ODBC-IBM-Db2/m-p/2126337#M7611 <P>Hello&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/249556">@DuongNguyen</a>&nbsp;,</P> <P>It's a glad to work with you. Thank you so much for your great support!</P> <P>Best,</P> <P>John.</P> Sun, 08 Oct 2023 05:46:42 GMT https://community.qlik.com/t5/Qlik-Replicate/I-run-task-replicate-from-SQL-Server-Source-to-ODBC-IBM-Db2/m-p/2126337#M7611 john_wang 2023-10-08T05:46:42Z