Re: Commit in SQR

[Denise White <dewhite@VICR.COM>]

Yes, in certain database types a commit while in the middle of a select will
indeed reset the cursor and cause the select to start all over again - creating
an infinite loop.  I found this out some years back when we converted from
SQLBase to Oracle.  It did not cause a problem in SQLBase, so I wasn't prepared
for that problem in Oracle.  I don't know of any solution other than to remove
the commit.  It is sometimes risky to do commits in SQR, anyway, because if the
program abends after doing any commits, it may be difficult to rerun the job
because you may then get duplicate key errors if you're doing inserts, or if
you're adding to a field in a table, that will end up doubled up, etc..

Denise White
Sr. Software Engineer
Vicor
------------------------------

Date:    Wed, 22 May 2002 15:50:02 -0500
From:    Bill Beckner <Bbeckner@ICC.EDU>
Subject: Re: Commit in SQR

For DB2/UNIX databases it does... :(  I found this out just this Monday....

--
William Beckner -- Stunt Programmer (Just call me "Bill")
Illinois Central College, Rm L141 -- East Peoria, IL  61635-0001
PH: (309) 694-8419 -- FAX: (309) 694-8995
"Someday, we'll look back on this, laugh nervously and change the subject."

 -----Original Message-----
From:   Lynds,Rick [mailto:rlynds@MWDH2O.COM]
Sent:   Wednesday, May 22, 2002 3:24 PM
To:     SQR-USERS@list.iex.net
Subject:        Re: Commit in SQR

I believe that I read somewhere (probably from this group) that a commit can
reset the cursor used for selects.  Can anyone verify that?

Rick

-----Original Message-----
From: razeel zaleel [mailto:ana_zaleel@YAHOO.COM]
Sent: Wednesday, May 22, 2002 12:59 PM
To: SQR-USERS@list.iex.net
Subject: Commit in SQR


Hi Guys,

i am trying to COMMIT before the SQR ends that is in
between i am selecting some records on certain
condition then i update and COMMIT
but the program goes into infinite loop

any help

Thanks in advance
khan