Reading a flat file

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.


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

Dig deeper on DB2 UDB (universal databases)

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.



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: