Re: Commit in SQR

[Bill Beckner <Bbeckner@ICC.EDU>]

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

__________________________________________________
Do You Yahoo!?
LAUNCH - Your Yahoo! Music Experience
http://launch.yahoo.com