Hello Sam,

When you use SQL "create global temporary table sam as select * from temp" I think your do an implicit commit.
As you don't specify any statement for action "on commit" all your rows from temp are deleted.

Maybe you could try to change your statement with "create global temporary table sam on commit preserve rows as select * from temp"?


Regards,
Steph.