RE: SQL AS/400 Question

["Schenck, Don" <Don.Schenck@xxxxxx>]

If your SQL statement is "SELECT ...", then the row is NOT locked.

If it's "UPDATE ..." then the row is locked for the millisecond it takes to
perform the update.

-- Don

-----Original Message-----
From: joberhol@compures.com [mailto:joberhol@compures.com]
Sent: February 24, 2000 11:37 AM
To: MIDRANGE-L@midrange.com
Cc: mgraziano@badgermeter.com
Subject: Re: SQL AS/400 Question


*SNIP
Does any know if when an SQL is being done in a program, does it lock by
Rows or Records.

*ENDSNIP

Marie,

In the case you site, there is no difference between the two terms.  A Row
is a Record.  If the rows are retrieved for update, then yes they are being
locked.  All access paths with immediate  maintenance indexes will also be
siezed long enough the the key updates to be done if there are any.

Jim Oberholtzer


+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator:
david@midrange.com
+---
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---