https://community.qlik.com/t5/Talend-Studio/teradataOutput/m-p/2332655#M101511 Hello <BR />Go to the 'advanced settings' and set the commit every field as 0 will solve the problem. <BR />Best regards <BR />Shong Tue, 30 Mar 2010 09:47:33 GMT Anonymous 2010-03-30T09:47:33Z https://community.qlik.com/t5/Talend-Studio/teradataOutput/m-p/2332654#M101510 I am getting the following error extracting from a table and inserting into a another table in teradata.<BR />Exception in component tTeradataOutput_1<BR />com.ncr.teradata.jdbc_4.util.JDBCException: : Only an ET or null statement is legal after a DDL Statement.<BR /> at com.ncr.teradata.jdbc_4.statemachine.ReceiveInitSubState.action(ReceiveInitSubState.java:92)<BR /> at com.ncr.teradata.jdbc_4.statemachine.StatementReceiveState.subStateMachine(StatementReceiveState.java:270)<BR /> at com.ncr.teradata.jdbc_4.statemachine.StatementReceiveState.action(StatementReceiveState.java:161)<BR /> at com.ncr.teradata.jdbc_4.statemachine.StatementController.runBody(StatementController.java:100)<BR /> at com.ncr.teradata.jdbc_4.statemachine.StatementController.run(StatementController.java:91)<BR /> at com.ncr.teradata.jdbc_4.Statement.executeStatement(Statement.java:287)<BR /> at com.ncr.teradata.jdbc_4.Statement.prepareRequest(Statement.java:441)<BR /> at com.ncr.teradata.jdbc_4.PreparedStatement.&lt;init&gt;(PreparedStatement.java:51)<BR /> at com.ncr.teradata.jdbc_4.TDSession.createPreparedStatement(TDSession.java:353)<BR /> at com.ncr.teradata.jdbc_3.ifjdbc_4.TeraLocalPreparedStatement.&lt;init&gt;(TeraLocalPreparedStatement.java:86)<BR /> at com.ncr.teradata.jdbc_3.ifjdbc_4.TeraLocalConnection.prepareStatement(TeraLocalConnection.java:323)<BR /> at com.ncr.teradata.jdbc_3.ifjdbc_4.TeraLocalConnection.prepareStatement(TeraLocalConnection.java:145)<BR /> at bmg_java.bmg_0_1.bmg.tTeradataInput_2Process(bmg.java:676)<BR /> at bmg_java.bmg_0_1.bmg.runJobInTOS(bmg.java:1211)<BR /> at bmg_java.bmg_0_1.bmg.main(bmg.java:1106) Sat, 16 Nov 2024 13:29:12 GMT https://community.qlik.com/t5/Talend-Studio/teradataOutput/m-p/2332654#M101510 Anonymous 2024-11-16T13:29:12Z https://community.qlik.com/t5/Talend-Studio/teradataOutput/m-p/2332655#M101511 Hello <BR />Go to the 'advanced settings' and set the commit every field as 0 will solve the problem. <BR />Best regards <BR />Shong Tue, 30 Mar 2010 09:47:33 GMT https://community.qlik.com/t5/Talend-Studio/teradataOutput/m-p/2332655#M101511 Anonymous 2010-03-30T09:47:33Z https://community.qlik.com/t5/Talend-Studio/teradataOutput/m-p/2332656#M101512 Hi Shong, <BR />I am facing the same problem in tTeradataRow component, even after changing the commit to 0 in Advanced settings. <BR />In my process, I am creating a volatile table and then insert records in that table. <BR />Let me know if there is better approach to accomplish this. <BR />Thanks <BR />Mahesh Singh Mon, 06 Jun 2016 19:06:19 GMT https://community.qlik.com/t5/Talend-Studio/teradataOutput/m-p/2332656#M101512 Anonymous 2016-06-06T19:06:19Z