I sometimes have 10 to 15 sessions running by one user, using temp tables Tom
On Thu, 3 May 2018, 5:18 PM Lena Dammstrom, <[email protected]> wrote: > Thanks Razzak. > I missed the "session specific" in my response! > > Regards > Lena > > -----Original Message----- > From: [email protected] <[email protected]> On Behalf Of A. > Razzak Memon > Sent: Thursday, May 03, 2018 4:52 PM > To: [email protected] > Subject: RE: [RBASE-L] - Does Table exist? > > Lena, > > FYI, TEMPORARY tables/views are "session specific" tables/views, meaning, > each session of R:BASE retains and maintains its own TEMPORARY > table(s)/view(s). > > Yes, your understanding of "Temp tables are unique/mutually exclusive for > each user" or session is correct! > > Temporary tables/views created by user Lena will NOT be seen by another > user, or even a separate session of R:BASE started by Lena. > > Hope that helps! > > Very Best R:egards, > > Razzak > > > At 05:31 PM 5/3/2018, Lena Dammstrom wrote: > > >Someone can correct me if I am wrong, but I have it in my head that > >Temp tables are unique/mutually exclusive for each user. > > > >I.e. TempTableA created by user Lena cannot be seen/used by user Doug > >and vice-versa So the same program called by Lena could create > >TempTableA and same program called by Doug would also TempTableA > > > >Regards > >Lena > > > >From: [email protected] > ><[email protected]> On Behalf Of Doug Hamilton > >Sent: Thursday, May 03, 2018 3:03 PM > >To: R:Base List <[email protected]> > >Subject: Re: [RBASE-L] - Does Table exist? > > > >Thanks Lena, Razzak and Buddy. > >The temp table is in an item maintenance routine. I don't want to > >delete it if there are other parts being edited by the same user. > >I was going to create a unique temp table for each part, but that got > >ugly real fast. > > > >Doug > > > >On 5/1/2018 11:04 AM, Buddy Walker wrote: > > > >I think doing a COUNT(*) FROM SYS_TABLES is the best way to check for > >an existing table. With that being said and you truly want to > >delete/drop a TEMPORARY table then recreate it I would just turn the > >error message off and drop the table then turn the error message back > >on. > > > > SET ERROR MESSAGE 2038 OFF > > DROP myTempTblName > > SET ERR0R MESSAGE 2038 ON > > CREATE TEMPORARY myTempTblName ……… > >/p> > >Buddy > > > > > >From: > ><mailto:[email protected]>[email protected] > ><mailto:[email protected]><[email protected]> > >On Behalf Of Lena Dammstrom > >Sent: Tuesday, May 1, 2018 11:41 AM > >To: <mailto:[email protected]>[email protected] > >Subject: RE: [RBASE-L] - Does Table exist? > > > >Doug, I be interested in a more elegant way of checking for the > >existence of a table too! > > > >I use the count method: > >SET VAR vCount = 0 > >SELECT COUNT(*) INTO vCount FROM Sys_Tables + > > WHERE Sys_Table_Name = 'TableName' AND LIMIT = 1 > > > > > >Regards > >Lena > >From: > ><mailto:[email protected]>[email protected] > ><<mailto:[email protected]>[email protected]> > >On Behalf Of Doug Hamilton > >Sent: Tuesday, May 01, 2018 10:33 AM > >To: R:Base List > ><<mailto:[email protected]>[email protected]> > >Subject: [RBASE-L] - Does Table exist? > > > >I'm drawing a blank - is there a > >command/function (in 9.5) to check for the existence of a table? > >I want to see if a temp table exists before I try to recreate it. > > > >I could try to count rows and check for error messages if the table > >isn't there but I suspect there's a more elegant method. > >'Course, recreating an existing table would also give an error message... > > > >TIA, > >Doug > >Now to get more coffee.... > > > ><https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_c > >ampaign=sig-email&utm_content=emailclient&utm_term=icon> > >Image removed by sender. > > > >Virus-free. > ><https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_c > >ampaign=sig-email&utm_content=emailclient&utm_term=link>www.avast.com > > > >-- > >For group guidelines, visit > ><http://www.rbase.com/support/usersgroup_guidelines.php>http://www.rbas > >e.com/support/usersgroup_guidelines.php > >--- > >You received this message because you are subscribed to the Google > >Groups "RBASE-L" group. > >To unsubscribe from this group and stop receiving emails from it, send > >an email to > ><mailto:[email protected]> > [email protected]. > >For more options, visit > ><https://groups.google.com/d/optout>https://groups.google.com/d/optout. > >-- > >For group guidelines, visit > ><http://www.rbase.com/support/usersgroup_guidelines.php>http://www.rbas > >e.com/support/usersgroup_guidelines.php > >--- > >You received this message because you are subscribed to the Google > >Groups "RBASE-L" group. > >To unsubscribe from this group and stop receiving emails from it, send > >an email to > ><mailto:[email protected]> > [email protected]. > >For more options, visit > ><https://groups.google.com/d/optout>https://groups.google.com/d/optout. > >-- > >For group guidelines, visit > ><http://www.rbase.com/support/usersgroup_guidelines.php>http://www.rbas > >e.com/support/usersgroup_guidelines.php > >--- > >You received this message because you are subscribed to the Google > >Groups "RBASE-L" group. > >To unsubscribe from this group and stop receiving emails from it, send > >an email to > ><mailto:[email protected]> > [email protected]. > >For more options, visit > ><https://groups.google.com/d/optout>https://groups.google.com/d/optout. > > > > > >-- > >For group guidelines, visit > ><http://www.rbase.com/support/usersgroup_guidelines.php>http://www.rbas > >e.com/support/usersgroup_guidelines.php > >--- > >You received this message because you are subscribed to the Google > >Groups "RBASE-L" group. > >To unsubscribe from this group and stop receiving emails from it, send > >an email to > ><mailto:[email protected]> > [email protected]. > >For more options, visit > ><https://groups.google.com/d/optout>https://groups.google.com/d/optout. > > > >-- > >For group guidelines, visit > ><http://www.rbase.com/support/usersgroup_guidelines.php>http://www.rbas > >e.com/support/usersgroup_guidelines.php > >--- > >You received this message because you are subscribed to the Google > >Groups "RBASE-L" group. > >To unsubscribe from this group and stop receiving emails from it, send > >an email to > ><mailto:[email protected]> > [email protected]. > >For more options, visit > ><https://groups.google.com/d/optout>https://groups.google.com/d/optout. > > > > -- > For group guidelines, visit > http://www.rbase.com/support/usersgroup_guidelines.php > --- > You received this message because you are subscribed to the Google Groups > "RBASE-L" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > For more options, visit https://groups.google.com/d/optout. > > -- > For group guidelines, visit > http://www.rbase.com/support/usersgroup_guidelines.php > --- > You received this message because you are subscribed to the Google Groups > "RBASE-L" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > For more options, visit https://groups.google.com/d/optout. > -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
