The default is ascending sequence. See SIGNED (Signed) keyword for physical and logical files for an example of data sorted using the DESCEND keyword. This ...
Multiple record non-join logical files will select records from 2 or more physical files by referring to only one logical file. · Each record format is always associated ...
The field name order is the order in which the fields appear to programs using the logical file. The name you give to a field in a logical file record format is typically ...
That is, a program may have to read a file sequentially in order by one or
You can normally get the same behaviour with an sorting index and a ...
Now SQL knows nothing about this thing called a logical file - it knows views and indexes. The iSeries implements those object types USING a ...
Let's modify this file definition to add key fields. If a physical file has key fields, programs can randomly access the records or read them sequentially in the order of ...
Contrary to native I/O where the programmer decides and explicitly defines the logical files to be used, in SQL the decision is made by the query ...
Logical files are paths the system can use to access the records in a physical file by using a different sequence and optionally selecting or omitting some records.
Each of these four things should be given its own PF (aka table). In the real world, any of them might even be best served by additional ...