|
In addition.... Check out the section on commitment control in chapter 19 of the SQL Programming Concepts manual. There is a table that shows "Row Lock Duration" (page 313 v5r2). HTH, Charles Wilt iSeries Systems Administrator / Developer Mitsubishi Electric Automotive America ph: 513-573-4343 fax: 513-398-1121 > -----Original Message----- > From: rpg400-l-bounces@xxxxxxxxxxxx > [mailto:rpg400-l-bounces@xxxxxxxxxxxx]On Behalf Of RPower@xxxxxxxxxx > Sent: Tuesday, May 17, 2005 2:32 PM > To: RPG programming on the AS400 / iSeries > Subject: SQL Question On Record Locks > > > Ok guys. This debate started here since we are taking an SQL > training > class. > It concerns how SQL handles record locking. If we use SELECT > * FROM TABLE > FOR UPDATE and the result set returns 100 records all of > name="RON" and I > want them updated to name="PAT". If a user goes to look at > one of those > records, at what point are the records updated, locked, etc? > Will the > user see RON or PAT during the processing? Does SQL lock one > record at a > time, or the whole 100? Thanks, > > Ron Power > Programmer > Information Services > City Of St. John's, NL > P.O. Box 908 > St. John's, NL > A1C 5M2 > Tel: 709-576-8132 > Email: rpower@xxxxxxxxxx > Website: http://www.stjohns.ca/ > ______________________________________________________________ > _____________ > Success is going from failure to failure without a loss of > enthusiasm. - > Sir Winston Churchill > -- > This is the RPG programming on the AS400 / iSeries (RPG400-L) > mailing list > To post a message email: RPG400-L@xxxxxxxxxxxx > To subscribe, unsubscribe, or change list options, > visit: http://lists.midrange.com/mailman/listinfo/rpg400-l > or email: RPG400-L-request@xxxxxxxxxxxx > Before posting, please take a moment to review the archives > at http://archive.midrange.com/rpg400-l. > >
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact copyright@midrange.com.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.