Problems with transactions...
This is a
multipart mime message
--Next_1098703398---0-202.54.124.151-10842
Content-type: text/html;
charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
<P>=0ADear All,<BR>=0A<BR>=0AI have IDS 9.3 on sun solaris 8. My data=
base is created with buffered logging. I execute the below steps in dbacces=
s<BR>=0A<BR>=0Abegin work;<BR>=0A<BR>=0Aexecute procedure 1;<BR>=0Aexecute =
procedure 2;<BR>=0A<BR>=0Acommit work;<BR>=0A<BR>=0AIf there is an error in=
procedure 2 it should ever rollback the procedure 1 statement.<BR>=0A<BR>=
=0AAnother example -<BR>=0A<BR>=0Abegin work;<BR>=0Ainsert into emp (emp_id=
, name) values (1, "jack);<BR>=0Ainsert into emp (emp_id, name) values=
(2, "tom);<BR>=0Ainsert into employee (emp_id, name) values (3, "=
;tom);<BR>=0Acommit work;<BR>=0A<BR>=0AI have wrongly written entered=
the table name in the third sql statement. The above query inserts 2 recor=
ds in emp table and gives an error for table not found in the third stateme=
nt. I would want the statement to behave in such a way that if there =
is an error in the third statement, it should not insert the data in the fr=
ist two statements. I have also set the env variable DBACCNOIGN to 1,=
but still no luck. It still inserts data through the first 2 stateme=
nts and gives an error for the third. Any workarounds. Apprecia=
te ur feedback.<BR>=0A<BR>=0ARegards,<BR>=0A<BR>=0Alloyd<BR>=0A<BR>=0A<BR>=
=0A<BR>=0A<BR>=0A =C2=A0<BR>=0A=0A</P>=0A<br><br>=0A<A target=3D"_blank" HR=
EF=3D"http://clients.rediff.com/signature/track_sig.asp"><IMG SRC=3D"http:/=
/ads.rediff.com/RealMedia/ads/adstream_nx.cgi/www.rediffmail.com/inbox.htm@=
Bottom" BORDER=3D0 VSPACE=3D0 HSPACE=3D0></a>=0A
--Next_1098703398---0-202.54.124.151-10842
Content-type: text/plain;
charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
Dear All,=0A=0AI have IDS 9.3 on sun solaris 8. My database is created wit=
h buffered logging. I execute the below steps in dbaccess=0A=0Abegin work;=
=0A=0Aexecute procedure 1;=0Aexecute procedure 2;=0A=0Acommit work;=0A=0AIf=
there is an error in procedure 2 it should ever rollback the procedure 1 s=
tatement.=0A=0AAnother example -=0A=0Abegin work;=0Ainsert into emp (emp_id=
, name) values (1, "jack);=0Ainsert into emp (emp_id, name) values (2, "tom=
);=0Ainsert into employee (emp_id, name) values (3, "tom);=0Acommit work;=
=0A=0AI have wrongly written entered the table name in the third sql state=
ment. The above query inserts 2 records in emp table and gives an error for=
table not found in the third statement. I would want the statement to beh=
ave in such a way that if there is an error in the third statement, it shou=
ld not insert the data in the frist two statements. I have also set the en=
v variable DBACCNOIGN to 1, but still no luck. It still inserts data throu=
gh the first 2 statements and gives an error for the third. Any workaround=
s. Appreciate ur feedback.=0A=0ARegards,=0A=0Alloyd=0A=0A=0A=0A=0A =C2=A0=
=0A
--Next_1098703398---0-202.54.124.151-10842--