https://community.qlik.com/t5/Talend-Studio/How-to-insert-the-same-row-into-different-DB-tables-that-have/m-p/2213854#M10948 <P>Hello,</P> <P>&nbsp;</P> <P>I guess this should be easily done but all my tests failed so far !</P> <P>I have to same data in different tables having the same structure. I have this scenario :</P> <P><BR />-&nbsp; tables belongs to the same database but do have different tablename<BR />or<BR />-&nbsp; tables belongs to different databases but have the same tablename.</P> <P>&nbsp;</P> <P>Today I'm putting all DBInput in a daisy row.</P> <P>&nbsp;</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="DBInput in daisy row" style="width: 580px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009MZhT.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/154000iC00C7BDB35D9612B/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MZhT.png" alt="0683p000009MZhT.png" /></span><SPAN class="lia-inline-image-caption" onclick="event.preventDefault();">DBInput in daisy row</SPAN></SPAN></P> <P>This worked a bit but I'm getting today a java execption telling me that my mainmethod cannot exceed 65435 char....</P> <P>Is this possible to adapt this and iterating through a list of tablename / database name and modify the tDBInput.tableName or tDBINput.databaseName property with java code on each iteration through the list?</P> <P>&nbsp;</P> <P>Thank you for your help.</P> <P>&nbsp;</P> <P>Regards</P> <P>&nbsp;</P> <P>Stéphane</P> Sat, 16 Nov 2024 02:10:29 GMT Anonymous 2024-11-16T02:10:29Z https://community.qlik.com/t5/Talend-Studio/How-to-insert-the-same-row-into-different-DB-tables-that-have/m-p/2213854#M10948 <P>Hello,</P> <P>&nbsp;</P> <P>I guess this should be easily done but all my tests failed so far !</P> <P>I have to same data in different tables having the same structure. I have this scenario :</P> <P><BR />-&nbsp; tables belongs to the same database but do have different tablename<BR />or<BR />-&nbsp; tables belongs to different databases but have the same tablename.</P> <P>&nbsp;</P> <P>Today I'm putting all DBInput in a daisy row.</P> <P>&nbsp;</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="DBInput in daisy row" style="width: 580px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009MZhT.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/154000iC00C7BDB35D9612B/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MZhT.png" alt="0683p000009MZhT.png" /></span><SPAN class="lia-inline-image-caption" onclick="event.preventDefault();">DBInput in daisy row</SPAN></SPAN></P> <P>This worked a bit but I'm getting today a java execption telling me that my mainmethod cannot exceed 65435 char....</P> <P>Is this possible to adapt this and iterating through a list of tablename / database name and modify the tDBInput.tableName or tDBINput.databaseName property with java code on each iteration through the list?</P> <P>&nbsp;</P> <P>Thank you for your help.</P> <P>&nbsp;</P> <P>Regards</P> <P>&nbsp;</P> <P>Stéphane</P> Sat, 16 Nov 2024 02:10:29 GMT https://community.qlik.com/t5/Talend-Studio/How-to-insert-the-same-row-into-different-DB-tables-that-have/m-p/2213854#M10948 Anonymous 2024-11-16T02:10:29Z