topic Excute statement failed. Table name in User not valid for operation (Task with ODBC(IBM DB2 for iSeries) as target) in Qlik Replicate https://community.qlik.com/t5/Qlik-Replicate/Excute-statement-failed-Table-name-in-User-not-valid-for/m-p/2128332#M7720 <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="DuongNguyen_1-1697196703357.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/118206i52407866D7EC6A47/image-size/medium?v=v2&amp;px=400" role="button" title="DuongNguyen_1-1697196703357.png" alt="DuongNguyen_1-1697196703357.png" /></span></P> <P>how to fix it?</P> <P>&nbsp;</P> Fri, 13 Oct 2023 11:32:16 GMT DuongNguyen 2023-10-13T11:32:16Z Excute statement failed. Table name in User not valid for operation (Task with ODBC(IBM DB2 for iSeries) as target) https://community.qlik.com/t5/Qlik-Replicate/Excute-statement-failed-Table-name-in-User-not-valid-for/m-p/2128332#M7720 <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="DuongNguyen_1-1697196703357.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/118206i52407866D7EC6A47/image-size/medium?v=v2&amp;px=400" role="button" title="DuongNguyen_1-1697196703357.png" alt="DuongNguyen_1-1697196703357.png" /></span></P> <P>how to fix it?</P> <P>&nbsp;</P> Fri, 13 Oct 2023 11:32:16 GMT https://community.qlik.com/t5/Qlik-Replicate/Excute-statement-failed-Table-name-in-User-not-valid-for/m-p/2128332#M7720 DuongNguyen 2023-10-13T11:32:16Z Re: Excute statement failed. Table name in User not valid for operation (Task with ODBC(IBM DB2 for iSeries) as target) https://community.qlik.com/t5/Qlik-Replicate/Excute-statement-failed-Table-name-in-User-not-valid-for/m-p/2128440#M7724 <P><a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/249556">@DuongNguyen</a>&nbsp;</P> <P>&nbsp;</P> <P>Hello,</P> <P>It appears to me that you are attempting to INSERT into DB2i but there is no journaling turned on for the target.</P> <P>Please show the error to your DB2i DBA and they can correct the issue.&nbsp; See this Google'd link below for some information.&nbsp;</P> <P><A href="https://stackoverflow.com/questions/6388834/error-sql7008-while-updating-a-db2-for-iseries-table" target="_blank" rel="noopener">java - Error SQL7008 while updating a DB2 for iSeries table - Stack Overflow</A></P> <P>&nbsp;</P> <P>Let us know when the issue is resolved.&nbsp;</P> <P>&nbsp;</P> <P>Sincerely,</P> <P>Barb</P> Fri, 13 Oct 2023 16:52:51 GMT https://community.qlik.com/t5/Qlik-Replicate/Excute-statement-failed-Table-name-in-User-not-valid-for/m-p/2128440#M7724 Barb_Fill21 2023-10-13T16:52:51Z