Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


When we use any keyword like FIFO,LIFO, at file level but whenever we check by runqry we couldn't find answer in FIFO,LIFO,FCFO etc so how we check the answer.

Answers were Sorted based on User's Feedback



When we use any keyword like FIFO,LIFO, at file level but whenever we check by runqry we couldn�..

Answer / satyabrata

UNIQUE: A record cannot be entered or copied into a file if its key value is same as the key value of a record already existing in the file.

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 ?    1 Yes 0 No

When we use any keyword like FIFO,LIFO, at file level but whenever we check by runqry we couldn�..

Answer / vivek dwivedi

Use the DSPF command to check effect of LIFO,FIFO

Is This Answer Correct ?    1 Yes 1 No

Post New Answer

More DB400 Interview Questions

What is the difference between access path and open data path?

0 Answers  


what is general and type of general

1 Answers   Active Brains,


Maximum how many fields we can create under a record format of PF?

5 Answers  


Why we create the Physical File Member?

5 Answers  


When u create a PF and did not fill up Maint parameter, then by default which access path will the system take & why

2 Answers   HCL,


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

0 Answers  


hi iam very new to as400. i had created one physical file can any one tell command to enter data in to that

9 Answers   Encore,


In how many ways we can create a logical file?`

5 Answers  


what is the intractive job? what is the batch job ? how to change the batch job to interactive job?

2 Answers   Four soft,


I want to change the attribute of field or want to add new field in existing PF but condition is format level identifier should not change, is it possible?

9 Answers   Mind Tree, TCS,


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  


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

4 Answers   Cap Gemini,


Categories