RE: How to avoid Error 3460
Posted in 1997
Hi Aman,
You can use :
SET LOCK MODE TO WAIT
Munaf
g086mnf@bomplant3.appl.ge.com
----------
From: informix-list-owner[SMTP:informix-list-owner@rmy.emory.edu]
Sent: Tuesday, January 14, 1997 4:27 AM
To: informix-list@rmy.emory.edu
Subject: How to avoid Error 3460
Hi Informix Gurus,
I am new to the world of Informix, so my question might be very
elementry for
most of you. I have observed that transactions return with error code
-3460
if record being fetched is locked by some other transaction. Is it
possible
that transactions wait for lock to be released instead of returing with
the error
code ?
Thanks,
Aman
The following binary file has been uuencoded to ensure successful
transmission. Use UUDECODE to extract.
begin 600 WINMAIL.DAT
M>)\\^(@4+`0:0"``$```````!``$``0>0!@`(````Y`0```````#H``$(@`<`
M&````$E032Y-:6-R;W-O9G0@36%I;"Y.;W1E`#$(`0V`!``"`````0`!``$$
M@`$`'````%)%.B!(;W<@=&\\@879O:60@17)R;W(@,S0V,`!L"`$%@`,`#@``
M`,T'`0`.`!``*P`"``(`(@$!((`#``X```#-!P$`#@`0`"D`$@`"`#`!`0F`
M`0`A````,$5$,#@R,D$Q0S9%1#`Q,4)!0S0P,$$P,C1#1$0Q,$4`+0<!`Y`&
M`#P$```0````"P`C```````#`"8``0````L`*0```````P`V``````!``#D`
M(*:%Z`L"O`$>`'```0```!P```!213H@2&]W('1O(&%V;VED($5R<F]R(#,T
M-C```@%Q``$````6`````;P""^B%*H+0#VX<$="ZQ`"@),W1#@```P`&$.O9
M@-H#``<0_0$``!X`"!`!````90```$A)04U!3BQ93U5#04Y54T4Z4T543$]#
M2TU/1$543U=!251-54Y!1D<P.#9-3D9`0D]-4$Q!3E0S05!03$=%0T]-+2TM
M+2TM+2TM+4923TTZ24Y&3U)-25@M3$E35"U/5TY%4E,``````@$)$`$```#Q
M`@``[0(``(`%``!,6D9U9MX6T?\\`"@$/`A4"J`7K`H,`4`+R"0(`8V@*P'-E
M=#(W!@`&PP*#,@/%`@!P<D)Q$>)S=&5M`H,SMP+D!Q,"@S02S!3%?0J`BPC/
M"=D[%Y\\R-34"@`<*@0VQ"V!N9S$P,R\\44`L*%%$+\\F,`0"!(IFD4L`.!+"`*
MA5D(8)0@8P.1=1&P(#H*A0!3150@3$]#2P$%T$]$12!43R`X5T%)'N`*A0J%
M374(;F%F"H5G,#@VT&UN9D`&X&T+40(P$#,N87`+4"YG91HN!:!M("P*]&QI
M,00X,`+1:2TQ-#3/#?`,T"5S"UDQ-@J@`V#U$]!C!4`M)Y<*AR9+##!U)Q9&
M`V$Z*)XG%@R"((,+@`(0<FUI>"TDT"$3P"UO=VX$D%M3L$U44#HL7P200"R0
M''DN$^`%L"]!9'5=OR@_*4T&8`(P*G\\KBU0*4%!S9&%Y'/!*`'!U&0K`>2`E
M<!SP,3DY(#<@-#HR-:!!3?,P#RE-5&\\R3RN/+)<O'.,V/S$>=6)J)U$X7SEK
M`D@M,"!T;R!A=L!O:60@17(#8`7`V#,T-@IV)`TS08`;79<G%@J%'(%)+?4@
M1PAP+1X`+"`L1P%)0)!M(%,M4$!3=&@>('<%L&S90.!O9D4W'/!S0(`O,&0@
M<30Q=&D"($F0:=1G:`5`8AX@=@20-1#S1P`*A65L$^`R$34!+@&O"H4$8!/`
M2))Y"&`N1R+7$8!*\\$B08A&P<DKP0.#]2`!A!4!,,`!Q`-!*$@0@_1>@=`AP
M`Z`#\\$@`2\\!!$_<%H`VP2S@M06D&D%`!!:'W0.!*P`N`9TQ@$<`1<$[!I00`
M(!<P8VM.P6(U$/])<`>`2)!(`07`3TE-P@0@NU"02SAP32``D`)@90J%_T[_
M2#`+<`5`+@%4<T!B2L%[%Z!+X&$1L%0Q`(`3T&'_2(-0$U.24(-+1T@"4-,*
MA951,S\\@+%01@&YK1A??'+)'`D&O0KX58C(2L$0M!1;!`&3P`````P`0$```
M```#`!$0`````$``!S#@:TBJ"P*\\`4``"##@:TBJ"P*\\`1X`/0`!````!0``
+`%)%.B``````[B\\`
`
end