• Subject: Re: Looking up a record by key field
  • From: "Gary Morrison" <gmorrison@xxxxxxxxxxxxxxx>
  • Date: Thu, 28 Dec 2000 09:39:02 -0500

I may be missing something here, but the read commands are the same, you just
define the file(s) as  keyed or sequential.   Usually a  physical file  (type
PF) is not defined with a key, the logical file (type LF) isused to key the
file.

Gary




Dan Taylor <dtaylor@ecdh.org> on 12/27/2000 04:40:08 PM

Please respond to COBOL400-L@midrange.com

To:   "Cobol400-L Mailing List (E-mail)" <cobol400-l@midrange.com>
cc:    (bcc: Gary Morrison/IS/Celina)
Subject:  Looking up a record by key field




     I have been programming in COBOL in a VAX / VMS environment for a few
years and have discovered that the IBM AS/400 environment is significantly
different from what I had been used to.  Can anyone tell me what the ILE
COBOL400 statements are to:

1.  Select a master file (with patient-number as the key) to be read
sequentially.

2.  Select a supplemental patient data file (also with patient-number as
the key) in which I want to look up the corresponding patient number from
the master file.

3.  Read the supplemental data file by key field (patient number).

     In other words, I need to read each record of the master file
sequentially, look up the corresponding supplemental patient data in the
supplemental file (by patient number) if a supplemental record for the
patient exists, edit data in the fields of the supplemental file's record
(if it exists), then re-write the supplemental file's record.

Any assistance would be GREATLY appreciated.


Dan Taylor
Erie County Department of Health


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







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


As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2021 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.