Sysmaster - Tabelas Temporária

Posted in 2014

André Luiz Rufino — Mon, 20 Jan 2014 16:58:00 — source: IIUG Forums & Mailing Lists

Hi folks, I need to write a program that must run once, create some temporary tables and keep the session alive. The user must to be able to run again, without close the session. I need to drop temporary tables(if it deos exist) and recreate then again. Does anybody knows what sysmaster table can I access to find which temporary table belongs to my session. In others words, where are the temporary tables joined with session id ? Thanks a lot, André Luiz Rufino

↪ replying to André Luiz Rufino

Fernando Nunes — Mon, 20 Jan 2014 17:20:20 — source: IIUG Forums & Mailing Lists

I'm not absolutely sure I got your requirement correctly... You say: "a program that runs once .... keep the session alive": You cannot keep a session alive without a program running. Then you say: "I need to drop temporary tables (if they exist)" Ok... Just DROP them and capture the error... of if you're using 11.70 do "DROP TABLE IF EXISTS..." What you're requesting (gathering the current temporary tables of you session) is not possible currently. There is already a feature request for it, created by Cesar Martins I believe, so please vote for it, if it suites your needs: http://www.ibm.com/developerworks/rfe/execute?use_case=viewRfe&CR_ID=36245 We're still missing a feature for knowng who is using the temporary tables which should be linked to this one I believe. Regards On Mon, Jan 20, 2014 at 4:58 PM, André Luiz Rufino <andre_rufino@msn.com>wrote: > Hi folks, > I need to write a program that must run once, create some temporary tables > and > keep the session alive. The user must to be able to run again, without > close > the session. I need to drop temporary tables(if it deos exist) and recreate > then again. > Does anybody knows what sysmaster table can I access to find which > temporary > table belongs to my session. > In others words, where are the temporary tables joined with session id ? > Thanks a lot, > André Luiz Rufino > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently... --001a11337576f74bf904f06a1a79