Export temporary table in automation script

Toad for IBM DB2
1

Hi

I'm having troubles exporting the contents of a global temporary table into an excel via the "automation script" option.

So far I've read that it is necessary to have the tick option in the "connection manager" ticked and the connection upon start.

I also preserve the rows after commit, however I still get the error message that my temporary table does not exist.

Is there anything I am missing?

Thanks so much for any help!

Julia

2

I would suggest breaking up your script to small simple pieces.
Do a simple loopdataset that does nothing but selects one row from the temp table.
I suspect that the problem might be the connection configuration.
Another thing you should be aware of is that in Toad automation the schema has to be explicit.
I found the the statement SET schema is not enough.
Shimon