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.
Jonathan Leffler — — source: Informix-list mailing list archive (1991-1998)
Temporary tables are unique to the process creating them; they cannot be
seen by any other process at any time. The use of the owner name is
redundant. You've probably found a bug, which should probably be reported
to Informix Tech Support, but the workaround is obvious and safe for all
versions of Informix -- do not use the owner name on temporary tables.
Note that even if the same user is running the same program on two
different terminals concurrently (or even the same terminal), the temp
tables in the first process are completely disjoint from the temp tables of
the second process.
Yours,
Jonathan Leffler (johnl@informix.com) #include <disclaimer.h>
PS: The only privilege problem seems to be universal access to an English
dictionary. The number of times this word is misspelled is apalling!
}From: keiths@prestongates.com
}Subject: ISAM error: the file is locked???
}Date: 26 Jun 1996 16:47:15 GMT
}X-Informix-List-Id: <news.25453>
}
}I get an SQL error -242 "could not open database table (username.tempapply)
}System error number -113
}ISAM error: the file is locked
}
}This seems to happen only on temporary tables that are created with the
}user name as a prefix. This is supposed to make it unique so that when
}someone else is running another program that creates the same temporary
}table with a different user name as a prefix.
}
}This was not a problem in 5.01 but seems to be in 7.12.
}Is there a priviledge problem?
}
}Help!
}Keith
}
}Please send responses to keiths@prestongates.com
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.