Answer Posted / pratap thakur
These keywords are used at file level. The purpose of each one is described below:
FIFO: The duplicate key records will retrieved in first in first out order.
LIFO: The duplicate key records will retrieved in last in first out order.
FCFO: The duplicate key records will retrieved in first changed first out order.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
i am using non join multiple format my 3 database file is like that pf97 R REC ENAME ETENNO ESTATUS K ENAME pf98 R REC1 ENAME ESAL K ENAME PF99 R REC3 ENAME CRDCARD EID K EID & MY NON JOIN LOGICAL FILE IS ALSO SAME EXCEPT RECORD NAMES BEFORE I TRIED WITH 2 FILES SO ITS SAYS ERROR I.E.(Key field attributes must be same as for previous formats. ) SO I CHANGED KEYFIELD ACCORDING TO PF SO ITS WORKING BUT AFTER ADDING 3 FILES ITS SAYING SAME ERROR . I DONT KNOW I NEW IN AS400 PLLZ HELP ME I HAVE ONE MORE QUE. CANT BE USE DIFFERENT KEYFIELD (NOT ACCORDING TO PF) IN NON JOIN LOGICAL FILE.
how to write *pssr ?
how can database records be read without lock ?
an access path may be in which sequence?
What is file access opcodes?
describe the difference between the dowxx and douxx operations?
define what a data area is along with a brief example of what it may be used for?
How can we change the uppercase to Lowercase in RPG?
how can you execute a command from within an rpg program without calling a clp program?
how do you specify the number of records to roll in a subfile ?
what is the purpose of the indara keyword?
how many maximum spaces could be given in o specs?
which are the figurative constants used in rpg?
What Is The Error If We Don't Get Login Screen?
records can be read/update/deleted with which file?