Display Physical File Member – Help
The Display Physical File Member (DSPPFM) command displays a
physical database file member. Records are shown in arrival
sequence, even if the file has a keyed access path. You can page
through the file, locate a particular record by record number, or
specify a starting position in the record. You can also select a
character or hexadecimal display of the records.
I assume that SQL is reading the file in arrival sequence -default- since
you have the ability to define the sort sequence.
Reminder: All the commands on the iSeries are fully documented.
What you see on the iSeries help screens is what you will see in the manuals.
Records in DB2 are physically stored in arival sequence.
The SQL access is on the arrival sequence, it will probably use the keyed index if you include the order by clause.
DFU will show the records in keyed order.