RE: CHAIN or READ without lock

[SHISHIRKSINGH <SHISHIRKSINGH@xxxxxxx>]

I never had this exp, but if true, then what is the sol'n to a case where
the file is defined as Update in F specs, and a record has to be read
without any taking any locks. If the record is there, then take a lock on
that record and update it.



-----Original Message-----
From: fkolmann@revlon.com.au [mailto:fkolmann@revlon.com.au]
Sent: Friday, February 11, 2000 10:05 AM
To: RPG400-L@midrange.com
Subject: CHAIN or READ without lock 


Thought I would check if others have experience something like this.

The CHAIN or READ without lock is a new function (well sort of) , but do
you know it also READS LOCKED records.

We had duplicate invoice numbers in our order processing application.
It was caused by  the 'N'  (no lock ) on a CHAIN op.
I checked the manual and if you read the fine print, yes  you can read a
LOCKED record with
a CHAIN or READ  even if the file is opened for UPDATE, provided you use
a N to request a
read without lock.
Personally I stay away from the read without lock.


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