Re: Temp Tables
iftikhar_khan@mailcity.com wrote:
> I have a question about Temp tables of Informix.
>
> My source code fo Informix 4gl creates some temp tables after making
> some
> query. Now at anytime, I cannot know what table it created with what
> fields.
> But when I debug it then, at some moment, I will know what table it is
>
> creating. Now my question is Can I see these table and their data
> using
> dbaccess or there is some other way to see this table?
>
> I greatly appreciate your time.
> Regards,
> Iftikhar
>
> -----== Posted via Deja News, The Leader in Internet Discussion
> ==-----
> http://www.dejanews.com/ Now offering spam-free web-based
> newsreading
Hi Iftikhar,
I'm afraid that you cannot do it with dbaccess, because the engine
creates these
tables as temporary files (.dat + .idx) in the specified $DBTEMP
directory. Unless
you work at ISAM level with small programs (in C or other). The temp
tables created
are not available through systema tables (i.e. systables, syscolumns,
sysindexes and so on).
Cheers.
Claudio Duffini