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