Re: temp tables and ODBC

Posted in 1997

Ravi Joseph Pinto — 9 Sep 1997 00:08:26 -0400 — source: Informix-list mailing list archive (1991-1998)

In reply to ppereira@moneymailer.com's email about temp tables and ODBC, on 8 Sep 97 Hi Paul, > We are using VB,ASP,IIS,NT 4.0, CLI and Informix OWS 7.22 for an > application. We are utilizing temp tagbles to get the proper result set. > How can one drop temp tables so that they are available for the next > user. > Temp tables are unique for a user session and are automatically dropped when the session exits. Thus, if a session starts with user testuser and creates a temp table temptable1, then another session can be started by testuser to create temp table temptable1. After the sessions are over, the temp tables will be automatically dropped. > Thank you for your help ahead of time > > Paul Pereira > H.O.T! Coupons > HTH, Ravi... -- Ravi Joseph Pinto, mailto:ravi@in.dhl.com Senior Consultant, voice :91-22-8503000 Astra Infotech, Mumbai, India extn. 1531 If Network is computer, how come Sun makes servers, not routers ;-) PS : Standard disclaimers apply.