Re: RPG IV and CF-spec "keep it IBM"

[John P Carr <jpcarr@xxxxxxxxxxxx>]

<SNIP>

>>      Fld1   Fld2   Fld3
        aa       1          2
        bb       2          3
        cc       3          4

>>File is defined as Unique on Fld1. When I do setll on Second record(i.e.
>>with bb) and try to change bb to cc ad Eval fld2=9
>>and then update it gives me Duplicate Key error. Thats true it should give
>> that error.

>> My Requirement is to delete third record(i.e. with va;ue cc ) and update
>>2nd record
>>Please advise me how to do so.
>> Thanks Dinesh

Access bb record,    change field FLD1 to cc,  then do a DELETE opcode with
factor one being the key(or keylist).   Now re-access bb 
again and do the update to change it to cc.

John Carr

+---
| 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
+---END