Hi Gints Plivna
As i run into the same problem and you seam to have quite a some knowledge i try to explain the question again:
We have used a global temporary table for 2 years. Now the requirements have changed. Due to legacy reasons i want to do the following:
get_rid_of (plz replace with the correct statement/s) myTempTable;
create view myTempTable (...) as (...) ;
(and no, in production the name is not myTempTable )
Cheers Andy