If we use the file level keywords like LIFO, FIFO, FCFO in a file, can we see the impact of it by doing the run query of the file? if not how can we see the impact of these keywords.

Answers were Sorted based on User's Feedback



If we use the file level keywords like LIFO, FIFO, FCFO in a file, can we see the impact of it by do..

Answer / amit k singh

If you are using FIFO,LIFO,FCFO then you can't see the impact by using the runqry command as fifo,lifo,fcfo are used to retrieved the duplicate key records.

so you have to retrieve the records from the file using rpgle program.simply write a program to read a file which is using these file level keywords.:)

Is This Answer Correct ?    9 Yes 1 No

If we use the file level keywords like LIFO, FIFO, FCFO in a file, can we see the impact of it by do..

Answer / murali

We can see the impact while entering data through ud command

Is This Answer Correct ?    1 Yes 1 No

Post New Answer

More DB400 Interview Questions

How to update physical file using logical file with example?

0 Answers  


What is FORMAT keyword and its use?

0 Answers  


how to add a new field to a file without compiling it?

1 Answers  


What is the interactive job? What is the batch job?

0 Answers  


There is one string as A B C and wanted to display string as Shri A Shri B Shri C, how we can do this in sql? If we have around 100 values in string like this, each value should be displayed with initials as Shri.

0 Answers  






What is the primary file?

0 Answers  


A pf containing 100 records... my query is how to display from 11th record in the pf?

3 Answers  


Suppose if a physical file is having 1000 records, but i deleted 500 records from it. Here the concern is can the size of the file changes or it remains the same... kindly help me out with thorough xplanation.... Thanks in-advance...

6 Answers   ABC, TCS,


Q.1 how to implement the commitment control. 2.how to control commitment control from external program.

7 Answers   IBM,


i have a PF,it contains 5 members,how to access particular member data from logical file ?and what is the use of member in PF

3 Answers  


I have a pf, it contains 5 members, how to access particular member data from logical file?

0 Answers  


how can i know logical file belongs to which physical file without source?

3 Answers   Cap Gemini,


Categories