You are not logged in.
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?