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

How to know logical file belongs to which physical file without source?

1 Answers  


what is open data base command

1 Answers   Active Brains, Cognizant, CSC, CTS,


can any one tell me what is meant by PSSR? Kindly elaborate it...

1 Answers  


how can we write LF using flatfile.

9 Answers  


How to know the perticular record in pf with out reading?

2 Answers   Cap Gemini,


How can we know that a trigger has been added on a PF? and what is the purpose of adding a trigger?

3 Answers  


Why we create the Physical File Member?

5 Answers  


Is Constent can be define as a key field?

3 Answers  


Why journalling is compulsory before commitment control?

1 Answers  


What is the purpose of the chain and setll and setgt?

0 Answers  


what is the difference between adding keys & constraints into a phisical file

4 Answers   HSBC,


Define interactive jobs and batch jobs

6 Answers  


Categories