TEMP table info from systables

Posted in 2000

mohdanas@my-deja.com — Tue, 05 Dec 2000 18:59:10 GMT — source: Informix-list mailing list archive (1991-1998)

Can we retrieve temporary table information from systables or sysmaster..? Thanks and Regards Anas Sent via Deja.com http://www.deja.com/ Before you buy.

↪ replying to mohdanas@my-deja.com

Andrew Hamm — Thu, 14 Dec 2000 11:05:54 +1100 — source: Informix-list mailing list archive (1991-1998)

mohdanas@my-deja.com wrote in message <90jdtp$hko$1@nnrp1.deja.com>... >Can we retrieve temporary table information from systables or >sysmaster..? Yes. But you have to be quick sometimes... If you are looking to find out the schemas of the temp tables, you may be out of luck. Look at Chapter 34 "The sysmaster Database" of the - Administrators Guide for Informix Dynamic Server, or equivalent. check out sysmaster:systabinfo as a starting point, and perhaps a few of the "secret undocumented" tables mentioned but not described if you are desperate for schemas or something similar. Be prepared for it to change from version to version.