Ownership of (temp)tables.
Posted in 1992
Kristjan Gaukur Kristjansson — — source: Informix-list mailing list archive (1991-1998)
I'm having a bit of a problem with temptables. I'm using temptables for storing of select-results to use further later, and that works just fine. BUT, if I want to do two things at the same time that use the same temptable name, and so start the 4gl program in two windows, I get a conflict between the temptable(s) since in both cases it gets the same owner name, and that, the good book says, is not allowed. Now, the question is, is there any way to connect the tablename to the process id. instead of the users login name? Or even give temptables variable names? Or any other solutions? With thanks in advance, Gaukur. (gaukur@rhi.hi.is)