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.
Pazicky Ludovit — — source: Informix-list mailing list archive (1991-1998)
Hello all!
After not receiving any answer for five days I'm attempting to ask you
the same again.
In order to make a data conversion in a single table I wrote a stored
procedure in which I supposed to use disbling of triggers on that table.
After starting transaction in the body of the procedure I made
SET TRIGGERS FOR table DISABLED;
LOCK TABLE table IN EXCLUSIVE MODE;
some operations on the table (DELETE, UPDATE)
SET TRIGGERS FOR table ENABLED;
COMMIT;
This block appears in a foreach loop.
I compiled and tuned the procedure on a NT box with Informix-WGS
7.22UC1.
All worked fine.
Our customer has a SINIX server with IDS-7.3xxxx. When I started the
procedure I became on the first SET command
SQL Error: -215 Cannot open file for table table-name.
ISAM error: -106 non-exclusive access.
I was logged on as informix. I had all posible privileges granted. I had
exclusive access to the database, I tried the set commands separately in
dbaccess and they worked OK. Nothing helped.
I had to run script
SET TRIGGERS FOR table DISABLED;
EXECUTE PROCEDURE procedure();SET TRIGGERS FOR table ENABLED;
I don't understand it. Is it a bug or am I doing something restricted
(but the error is inadequate then) or I don't know what.
Thanks for any hints, suggestions.
BTW: The data conversion has been done, but for the future it will be
interesting for me.
Pazi
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Ludovit Pazicky Ludovit.Pazicky@swh.sk
SWH spol. s r. o.
Stromova 9 Tel.: +421/7/538 43 13
Bratislava
Slovak republic
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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.