Re: New dbaccess message
--0__=09BBE5E2DFF2FB6A8f9e8a93df938690918c09BBE5E2DFF2FB6A
Content-type: multipart/alternative;
Boundary="1__=09BBE5E2DFF2FB6A8f9e8a93df938690918c09BBE5E2DFF2FB6A"
--1__=09BBE5E2DFF2FB6A8f9e8a93df938690918c09BBE5E2DFF2FB6A
Content-type: text/plain; charset=ISO-8859-1
Content-transfer-encoding: quoted-printable
Hi,
This warning message was introduced with PTS#146535 fix.
Fix for this bug displays the warning message on screen for
interactive/non-interactive mode of dbaccess.If we are not in ANSI mode=
and
we
have not seen an open BEGIN statement(This situaion occurs when we use
begin
statements in SPL/TRIGGERS) but we detect that here is an open TXN then=
execute
the default action of COMMIT(implicit commit) and print a warning messa=
ge
that
a commit has occurred. Introduced new warning message that the open T=
XN
is
likely the result of an unhandled exception in a transactional stored
procedure.
Thanks and Regards,
Gaurav
=
"Isidre PONS =
ROCA" =
<ipons@dtgna.alta =
To
net.org> informix-list@iiug.org =
Sent by: =
cc
owner-informix-li =
st@iiug.org Subj=
ect
New dbaccess message =
=
12/21/2004 04:48 =
AM =
=
=
=
Hi all.
Work environment:
SO : Solaris 9 (64 bits)
IDS 9.4.UC4 (32 bits)
dbaccess
In this new version (for me) when we exit from dbaccess after begin a
transaction with out commit or roll back this transaction anf if we cho=
se
commit (from menu) we receive a message :
Warning:Data Commit is a result of an unhandled exception in TXN
PROC/FUNC/TRI
Anyone know the reason of this warning?
TIA.
--
Isidre PONS ROCA
BASE - Gesti=F3 d'Ingressos Locals
(Diputaci=F3 de Tarragona)
Sistemes d'Informaci=F3
Av President Lluis Companys 12-C
43005 - Tarragona
SPAIN
Tel # +34 977 253 404
Fax # +34 977 227 302
http://www.base.es
ipons@dtgna.altanet.org
--
sending to informix-list
=
--1__=09BBE5E2DFF2FB6A8f9e8a93df938690918c09BBE5E2DFF2FB6A
Content-type: text/html; charset=ISO-8859-1
Content-Disposition: inline
Content-transfer-encoding: quoted-printable
<html><body>
<p>Hi,<br>
<br>
This warning message was introduced with PTS#146535 fix.<br>
<br>
Fix for this bug displays the warning message on screen for<br>
interactive/non-interactive mode of dbaccess.If we are not in ANSI mode=
and we<br>
have not seen an open BEGIN statement(This situaion occurs when we use =
begin<br>
statements in SPL/TRIGGERS) but we detect that here is an open TXN then=
execute<br>
the default action of COMMIT(implicit commit) and print a warning messa=
ge that<br>
a commit has occurred. Introduced new warning message that the open TX=
N is<br>
likely the result of an unhandled exception in a transactional stored p=
rocedure.<br>
<br>
Thanks and Regards,<br>
Gaurav<br>
<img src=3D"cid:10__=3D09BBE5E2DFF2FB6A8f9e8a93df938@us.ibm.com" width=3D=
"16" height=3D"16" alt=3D"Inactive hide details for "Isidre PONS R=
OCA" <ipons@dtgna.altanet.org>">"Isidre PONS ROCA"=
<ipons@dtgna.altanet.org><br>
<br>
<br>
<table width=3D"100%" border=3D"0" cellspacing=3D"0" cellpadding=3D"0">=
<tr valign=3D"top"><td style=3D"background-image:url(cid:20__=3D09BBE5E=
2DFF2FB6A8f9e8a93df938@us.ibm.com); background-repeat: no-repeat; " wid=
th=3D"40%">
<ul>
<ul>
<ul>
<ul><b><font size=3D"2">"Isidre PONS ROCA" <ipons@dtgna.al=
tanet.org></font></b><font size=3D"2"> </font><br>
<font size=3D"2">Sent by: owner-informix-list@iiug.org</font>
<p><font size=3D"2">12/21/2004 04:48 AM</font></ul>
</ul>
</ul>
</ul>
</td><td width=3D"60%">
<table width=3D"100%" border=3D"0" cellspacing=3D"0" cellpadding=3D"0">=
<tr valign=3D"top"><td width=3D"1%" valign=3D"middle"><img src=3D"cid:3=
0__=3D09BBE5E2DFF2FB6A8f9e8a93df938@us.ibm.com" border=3D"0" height=3D"=
1" width=3D"58" alt=3D""><br>
<div align=3D"right"><font size=3D"2">To</font></div></td><td width=3D"=
100%"><img src=3D"cid:30__=3D09BBE5E2DFF2FB6A8f9e8a93df938@us.ibm.com" =
border=3D"0" height=3D"1" width=3D"1" alt=3D""><br>
<font size=3D"2">informix-list@iiug.org</font></td></tr>
<tr valign=3D"top"><td width=3D"1%" valign=3D"middle"><img src=3D"cid:3=
0__=3D09BBE5E2DFF2FB6A8f9e8a93df938@us.ibm.com" border=3D"0" height=3D"=
1" width=3D"58" alt=3D""><br>
<div align=3D"right"><font size=3D"2">cc</font></div></td><td width=3D"=
100%"><img src=3D"cid:30__=3D09BBE5E2DFF2FB6A8f9e8a93df938@us.ibm.com" =
border=3D"0" height=3D"1" width=3D"1" alt=3D""><br>
</td></tr>
<tr valign=3D"top"><td width=3D"1%" valign=3D"middle"><img src=3D"cid:3=
0__=3D09BBE5E2DFF2FB6A8f9e8a93df938@us.ibm.com" border=3D"0" height=3D"=
1" width=3D"58" alt=3D""><br>
<div align=3D"right"><font size=3D"2">Subject</font></div></td><td widt=
h=3D"100%"><img src=3D"cid:30__=3D09BBE5E2DFF2FB6A8f9e8a93df938@us.ibm.=
com" border=3D"0" height=3D"1" width=3D"1" alt=3D""><br>
<font size=3D"2">New dbaccess message</font></td></tr>
</table>
<table border=3D"0" cellspacing=3D"0" cellpadding=3D"0">
<tr valign=3D"top"><td width=3D"58"><img src=3D"cid:30__=3D09BBE5E2DFF2=
FB6A8f9e8a93df938@us.ibm.com" border=3D"0" height=3D"1" width=3D"1" alt=
=3D""></td><td width=3D"336"><img src=3D"cid:30__=3D09BBE5E2DFF2FB6A8f9=
e8a93df938@us.ibm.com" border=3D"0@