https://community.qlik.com/t5/Talend-Studio/Netezza-truncate-table/m-p/2203728#M4903 I cannot find a way to truncate a netezza table within TOS.... any ideas? I am trying to do a basic "truncate and re-load" operation on a table, and get the following error when using the "clear table" option on the tNetezzaOutput component:<BR />Exception in component tNetezzaOutput_1<BR />org.netezza.util.PSQLException: ERROR: TRUNCATE TABLE cannot run inside a BEGIN/COMMIT block<BR />I don't see any other options..... there should be a way to run some basic "truncate table foobar;" type SQL, right?<BR />thanks....<BR />--Ivan Sat, 16 Nov 2024 14:07:06 GMT Anonymous 2024-11-16T14:07:06Z https://community.qlik.com/t5/Talend-Studio/Netezza-truncate-table/m-p/2203728#M4903 I cannot find a way to truncate a netezza table within TOS.... any ideas? I am trying to do a basic "truncate and re-load" operation on a table, and get the following error when using the "clear table" option on the tNetezzaOutput component:<BR />Exception in component tNetezzaOutput_1<BR />org.netezza.util.PSQLException: ERROR: TRUNCATE TABLE cannot run inside a BEGIN/COMMIT block<BR />I don't see any other options..... there should be a way to run some basic "truncate table foobar;" type SQL, right?<BR />thanks....<BR />--Ivan Sat, 16 Nov 2024 14:07:06 GMT https://community.qlik.com/t5/Talend-Studio/Netezza-truncate-table/m-p/2203728#M4903 Anonymous 2024-11-16T14:07:06Z