Re[4]: transaction log withOUT begin work
Thanks for your responds.
Again, I'm having same problem with On-line 7.1. When I run following sql from
one of my window:
being work;
update table_a set (col1, con2) = (( select col1, col2 from table_b
where table_a.col4 = table_b.col4));
And, from another windows, if I ask status of table table_a and try to exit from
dbaccess, I get "Transaction:Commit Rollback" messages.
If this is causing because of ansi mode, is there is any way I can check this?
In ansi mode, if I rollback would it rollback all other transaction started by
other programs/other users?
Thanks
Susik
______________________________ Reply Separator _________________________________
}Subject: Re: Re[2]: transaction log withOUT begin work
}Author: INTERNET:aland@informix.com at CSERVE
}Date: 8/29/96 10:11 PM
}
}
}Sender: informix-list-owner@rmy.emory.edu
}Received: from rmy.rmy.emory.edu (rmy.rmy.emory.edu [170.140.97.4]) by
}arl-img-3.compuserve.com (8.6.10/5.950515)
} id WAA11282; Thu, 29 Aug 1996 22:09:45 -0400
}Received: (from ilist@localhost) by rmy.rmy.emory.edu (8.7.1/8.7.1) id
}WAA08845 for susik_lee@united#u#group.ccmail.compuserve.com; Thu, 29 Aug 1996
}22:10:10 -0400 (EDT)
}Date: Thu, 29 Aug 1996 15:15:40 -0700
}From: aland@informix.com (Alan Denney)
}Message-Id: <199608292215.PAA16784@ten_forward.informix.com>
}To: INFORMIX-LIST@rmy.emory.edu,
} Susik_Lee@united#u#group.ccmail.compuserve.com, aland@informix.com
}Subject: Re: Re[2]: transaction log withOUT begin work
}Cc: aland@informix.com
}Sender: informix-list-owner@rmy.emory.edu
}Reply-To: aland@informix.com (Alan Denney)
}X-Informix-List-To: susik_lee@united#u#group.ccmail.compuserve.com
}X-Informix-List-Id: <list.11192>
}
}} From Susik_Lee@United#u#Group.CCMAIL.CompuServe.COM Thu Aug 29 14:31 PDT
}1996
}} From: Susik_Lee@United#u#Group.CCMAIL.CompuServe.COM
}} To: <INFORMIX-LIST@RMY.EMORY.EDU>, <aland@informix.com>
}} Subject: Re[2]: transaction log withOUT begin work
}}
}} Hi Alan,
}} Thanks for your responds.
}}
}} I think this is NOT MODE ANIS database. Also, I have checked owner of
}} table and its O.K. (show as proadm1). In addition, I try to unload
}} table from dbaccess using "unload to junk select * from table" sql
}} command, than middle of unloading process I get "Unknown error number
}} 0" message.
}}
}} But, today I ran dbaccess without anyone accessing database and I was
}} able to display status of table. And when I exit from dbaccess, I was
}} NOT getting "TRANSACTION: Commit Rollback" message. Any ideal what's
}} happening.
}} Also, we are using On-line 5.01.UD2 on Sequent ptx2.1.5 with third
}} parity application call Claims 2000 from Continuum (Pro Systems).
}}
}} Thanks
}} Susik
}
}I still suspect ANSI mode was in effect. Is it possible that dbaccess was
}run with the -ansi flag or with DBANSIWARN set in the environment? (Or
}perhaps Claims 2000 sets the ANSI flag?
}
}
}
}--
}Alan Denney aland@informix.com
}
}"Eventually people realized that the Information Superhighway was
} essentially CB radio, but with more typing." -- Dave Barry
}