Re: -107 error is still there

On Dec 11, 10:32am, Tolis Varnas wrote: > Subject: -107 error is still there > > > A few days ago I posted an article about a problem with locking in > Online 7.11.UC1 on a HP-UX machine.Jim Gordon posted me an answer stating > that there was a syntax error on the create index command and that he couldn't > reproduce the error on his HP-box.The syntax error was a typo error, the index > exists on the test table and Informix Tech Support also can't reproduce the > error.So I asked the client to run again the SQL Skripts modifying the second > user script with the addition of the set lock mode to wait 180 command and to > sent me his onstat -k and onstat -u output.So here are the skripts: > Tolis, I'm sorry but I still don't get any error. My environment is 7.11.UC1X2 on HP 9000 I40 running A.09.04 HP/UX. This time the scripts ran without a problem but I don't get any lock message. The lock is held by the first script. Both scripts will run and both can then be committed. Cheers - Jim -- ----------------------------------------------------------------------------- Jim Gordon DHL Airways Inc. jgordon@us.dhl.com ----------------------------------------------------------------------------- My opinions are my own. They may vary with time but they remain mine!