RE: Temp Tables

Iftikhar Khan (iftikhar_khan@mailcity.com) wrote: >My source code for Informix 4gl creates some temp tables after making some >query. Now at anytime, I cannot know what table it created with what fields. That's true in general. Short of poking around in the SysMaster database, you cannot find out what temporary tables have been created by your process, much less what the columns of those tables are. >But when I debug it then, at some moment, I will know what table it is >creating. True. >Now my question is: Can I see these table and their data using dbaccess Absolutely not. They are private to the I4GL program; they wouldn't be any use if they were visible outside your I4GL program because then you'd have to worry about whether anybody else is also running a program which creates a temp table with the same name. > or there is some other way to see this table? I don't think there's any way to see the contents of the table except via the I4GL code which creates it. Yours, Jonathan Leffler (jleffler@visa.com) #include <bother.ms-exchange.h>