We can create an external described physical file using keys. In the program if we read this file, it will be read in keyed sequence. I now have a flat file (length 132 -- created using CRTPF command). I want to read that file in my RPG program in a particular sequence. Is it possible to read a flat file in sequence (using keys), and if yes how?

If you want to read the flat file in a particular sequence, then you could created a keyed logical file over the single column used in the definition of the flat file. Another possibility would be to use OPNQRYF and specify the single column as the keyfld.

==================================
MORE INFORMATION ON THIS TOPIC
==================================

Search400.com's targeted search engine: Get relevant information on DB2/400.

The Best Web Links: tips, tutorials and more.

Check out this online event, Getting the Most out of SQL & DB2 UDB for the iSeries.


This was first published in February 2003

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: