467,189 Members | 1,210 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,189 developers. It's quick & easy.

Insert into AS400 table locks bacuase of trigger

Hi

I am attemtpting to do a couple of inserts into an AS400page using a iSeries ODBC driver (CWBODBC.DLL 10.00.10.00). This works fine except on the last insert which is done on a table which has a trigger (after insert). The trigger seems to lock the session and as I dont receive a response after the insert the application hangs and the lock remains. If the trigger is removed the inserts work fine so the sql is ok.
Any hints?

/Bo
Sep 5 '07 #1
  • viewed: 1595
Share:

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

3 posts views Thread by Rebecca Lovelace | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.