Evaluate Weigh the pros and cons of technologies, products and projects you are considering.

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.

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.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.