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: Exception in component tNetezzaOutput_1 org.netezza.util.PSQLException: ERROR: TRUNCATE TABLE cannot run inside a BEGIN/COMMIT block I don't see any other options..... there should be a way to run some basic "truncate table foobar;" type SQL, right? thanks.... --Ivan
