Re: SQL AS/400 Question

["R. Bruce Hoffman, Jr." <rbruceh@xxxxxxxxxxxxx>]

Depends on what the statement is...

for example, if you are doing a group by function, then yes, the members of
the group are locked against updates during the processing of the group.

For upates, the record is locked for at least the duration of the update and
possibly longer based on the commitment control level of the program.

===========================================================
R. Bruce Hoffman, Jr.
 -- IBM Certified AS/400 Professional System Administrator
 -- IBM Certified AS/400 Professional Network Administrator

"The sum of all human knowledge is a fixed constant.
    It's the population that keeps growing!"

-----Original Message-----
From: Graziano, Marie <mgraziano@badgermeter.com>
To: 'Midrange' <MIDRANGE-L@midrange.com>
Date: Thursday, February 24, 2000 10:28 AM
Subject: SQL AS/400 Question


>Does any know if when an SQL is being done in a program, does it lock by
>Rows or Records.  I have a situation where a user is running a program on
>Two workstations and they take forever.  What I think may be happening is
>the row is locked until the 1st program finishes.
>
>Any feedback will be appreciated
>
>Marie Graziano
>
>+---
>| 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
+---