Accessing Temp Tables

Hi Folks, Is there any way to access the temporary table from another session which is not the owner of that table. I know this is an ancient question but you may have some magic tricks to make it happen. Thanks ! Gursoy YERLI

Yerli Gursoy Contr 311 HSW/YAMO wrote: > > Hi Folks, > > Is there any way to access the temporary table from another session which is > not the owner of that table. I know this is an ancient question but you may > have some magic tricks to make it happen. Thanks ! Nope. No tricks. No way. No how. Temp tables are session scoped and private. Art S. Kagel

In article <37AB16DC.404E663B@bloomberg.net>, Art S. Kagel <kagel@bloomberg.net> wrote: >Yerli Gursoy Contr 311 HSW/YAMO wrote: >> >> Hi Folks, >> >> Is there any way to access the temporary table from another session which is >> not the owner of that table. I know this is an ancient question but you may >> have some magic tricks to make it happen. Thanks ! > >Nope. No tricks. No way. No how. Temp tables are session scoped and >private. > >Art S. Kagel Sometimes when I am debugging a 4GL program I want to know what is in a temp table that the program creates. I generally add "unload to 'atable.unl' select * from atable" to the program at the appropriate point. Then in another window I can inspect that data. Depending what you are trying to do, you might try something like that. - Paul