RE: SQL AS/400 Question

["Graziano, Marie" <mgraziano@xxxxxxxxxxxxxxx>]

Yes,

Sorry for the mis-stating of the term.   

Marie Graziano

 -----Original Message-----
From:   Rob Berendt [mailto:rob@dekko.com] 
Sent:   Thursday, February 24, 2000 10:02 AM
To:     MIDRANGE-L@midrange.com
Subject:        Re: SQL AS/400 Question

There is no difference between a row and a record.

Perhaps your question was '... does it lock by Set or records?'  A set is a
group of rows.  For example:
UPDATE myfile
        SET FIELDA='TX'
        WHERE FIELDA='MN'
A set would be all rows where FIELDA='MN'

Sorry to be a pain, but I SUSPECT it locks by each individual row as it does
the update.





mgraziano@badgermeter.com on 02/24/2000 10:44:17 AM
Please respond to MIDRANGE-L@midrange.com@Internet
To:     MIDRANGE-L@midrange.com@Internet
cc:      
Fax to: 
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
+---
+---
| 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
+---