topic Fail to link Commit with table in Talend Studio https://community.qlik.com/t5/Talend-Studio/Fail-to-link-Commit-with-table/m-p/2237572#M25962 <P>Hi,I have a question regarding commit with table.</P> <P>I add a component called tdbCommit and try to link it with my source table "patientRecord" with OnSubjobOK</P> <P>But it seem cannot link together.</P> <P>Can anyone explain to me or teach me the solution. Appreciate it.</P> <P>This is using Microsoft SQL Server</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="image.png" style="width: 894px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009MZt6.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/128605iF3B26CD24DC3CD7C/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MZt6.png" alt="0683p000009MZt6.png" /></span></SPAN></P> Sat, 16 Nov 2024 02:31:15 GMT Anonymous 2024-11-16T02:31:15Z Fail to link Commit with table https://community.qlik.com/t5/Talend-Studio/Fail-to-link-Commit-with-table/m-p/2237572#M25962 <P>Hi,I have a question regarding commit with table.</P> <P>I add a component called tdbCommit and try to link it with my source table "patientRecord" with OnSubjobOK</P> <P>But it seem cannot link together.</P> <P>Can anyone explain to me or teach me the solution. Appreciate it.</P> <P>This is using Microsoft SQL Server</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="image.png" style="width: 894px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009MZt6.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/128605iF3B26CD24DC3CD7C/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MZt6.png" alt="0683p000009MZt6.png" /></span></SPAN></P> Sat, 16 Nov 2024 02:31:15 GMT https://community.qlik.com/t5/Talend-Studio/Fail-to-link-Commit-with-table/m-p/2237572#M25962 Anonymous 2024-11-16T02:31:15Z Re: Fail to link Commit with table https://community.qlik.com/t5/Talend-Studio/Fail-to-link-Commit-with-table/m-p/2237573#M25963 <P><A href="https://community.qlik.com/s/profile/0053p000007LR6SAAW">@jhau6</A>&nbsp;, use on component ok from tDBOutput and connect to tDBcommit.</P> Tue, 05 May 2020 06:11:41 GMT https://community.qlik.com/t5/Talend-Studio/Fail-to-link-Commit-with-table/m-p/2237573#M25963 manodwhb 2020-05-05T06:11:41Z Re: Fail to link Commit with table https://community.qlik.com/t5/Talend-Studio/Fail-to-link-Commit-with-table/m-p/2237574#M25964 <P>You don't to use commit component where you transaction is getting completed, not on the starting.</P> <P>You can also use AutoCommit in the tDBconnection's advance property and can remove the tDBCommit component.</P> Tue, 05 May 2020 07:21:38 GMT https://community.qlik.com/t5/Talend-Studio/Fail-to-link-Commit-with-table/m-p/2237574#M25964 Prakhar1 2020-05-05T07:21:38Z