A Logical file (LF) with Keys are Access path (INDEX) over the physical file (PF) and a Logical file (LF) with no key are VIEWS over the physical file (PF). A logical file (LF) can have a maximum …

Create a Join Logical file (JLF) with a key field. JLFA1 would have 3 fields namely ROLLNO, STUNAME, and CLASS from files PFA1 and PFA2, where the ROLLNO field is common in …

Jun 27, 2013 · To accomplish this join efficiently, you will want to ensure that you have a keyed access path (ie. an index) over each physical file (ie table) by the three location fields.

· We can filter the data with criteria by using select and omit command. · A logical file does not contain any data but provides the ‘VIEWS’ of the data to satisfy end-user’s needs. There are …

May 23, 2013 · Using logical files with crystal report, will pass only all fields in your logical files (LF). Use DSPFFD, to see all fields in the LF. If you want to limit number of fields in LF, create …

Aug 12, 2011 · There are actually many tiny differences between SQL created indexes/views and logical files created via DDS (that's the way of writing source files for your logical files (LF) and …

Mar 16, 2012 · Because the QADBKATR file is itself a logical file (similar to, but not exactly the same as a 'view'), it's relatively safe to query. By programming, the safest and essentially best …

Most of the time, a logical file is nothing more than a way of accessing the physical file with different key fields. With the standard AS/400 supplied tools, it is hard to see the logical file. …

Dec 1, 2014 · SQL indexes (as well as access paths located in DDS described logical files) are used by SQL for getting fast access to the data. SQL indexes can be used in composition with …

READ operation reads the records of a full procedural file. The READ OPCODE applies a record lock to files that are open in update mode.