Re: Transaction processing

[Ali Dosani <adosani@YAHOO.COM>]

yes





---George Mansoor <George.Mansoor@CSUN.EDU> wrote:
>
> Is anyone getting these list messages twice?
>
> On 22 Feb 99, at 14:18, Randle Boyd wrote:
>
> > Hi,
> >
> > We are running Maximo 3.02 (SQR v.3) on NT4 with Oracle 7.3.  I
was looking
> > at one of the SQRs that came with Maximo that updates the
Equipment table's
> > Year To Date Cost field with values from 4 other tables.  What
bothers me is
> > that these 4 tables are being marked as processed before the value
is
> > written to the Equipment table's Year To Date Cost field.  I
didn't see any
> > kind of Transaction Processing that would cause a rollback if the
update
> > failed.  I also work with PowerBuilder, and if I were going to
update 4
> > different table as part of one transaction, I would want to make
sure that
> > all the updates were successful before I committed the
transactions to the
> > database.  However, I don't see anything like that in this code.
> >
> > I know that SQR v.3 has commit and rollback commands as well as the
> > #sql-status variable, but I am not still not quite sure how
Transaction
> > Processing works, or should work in SQR.  If anyone has an example
or could
> > explain this to me, I would greatly appreciate it.
> >
> > TIA,
> > Randle
>
>
>
> --------------------------------------------------------------------
> George Mansoor                                  Cal State Northridge
> Systems & Technology/HR Project            Northridge, CA 91330-8335
> Tel: 818/677-5242
>

==
Dosani Ali

_________________________________________________________
DO YOU YAHOO!?
Get your free @yahoo.com address at http://mail.yahoo.com