Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
David Kosenko — — source: Informix-list mailing list archive (1991-1998)
Daniel Wood writes:
|> I have run into a problem where I get an SQL error of -242 which is
|> "Could not open database table (<TBLNAME>)" from a select statement.
|> The ISAM error is 0 which gives no indication as to why the table
|> could not be opened.
|>
|> It seems to happen when ispnopen() sees the tablespace flag of 0x20 set
|> in the tablespace slot in shared memory.
|>
|> The On-Line Administrator's Guide does not document the flag 0x20 in
|> the section on "tbstat -t". What is this flag?
It indicates that the tblspace in question is a temp table (at least in 5.X).
Dave
Disclaimer: The opinions expressed in this message are not those of Informix
Software, its partners or lackeys. Anyone who says otherwise is itching for
a fight.
****************************************************************************
"I look back with some satisfaction on what an idiot I was when I was 25,
but when I do that, I'm assuming I'm no longer an idiot." - Andy Rooney
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.