how to restrict upon adding the data for field reference file
in DB400



how to restrict upon adding the data for field reference file in DB400..

Answer / bhavana prs

While creating filed reference file we have to specify member option as *NONE. This means that we are not allowed to add data to that physical file without member. In this way we can restrict adding data to the field reference file.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More DB400 Interview Questions

How to retrieve a physical file after deleting that?

0 Answers  


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.

2 Answers  


How to retrieve a physical file after deleting that ? what is keyword used for that....??

6 Answers  


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.

2 Answers  


In a CL Program after executing a SQL SP how to receive a Output value from the SP. Just to make it clear I am sending 2 input and 1 output parameter to the SQL Stored Procedure. Now while receiving it output parm it is failing.

0 Answers   Nous,






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

3 Answers   Cap Gemini,


what is use of self join and which cases you will use this join

1 Answers   TCS,


what is general and type of general

1 Answers   Active Brains,


I have a PF with out any data but the dependent LF is having data?

1 Answers   HCL,


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

0 Answers  


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

0 Answers  


Last statement of any RPG pgm is LR?

5 Answers  


Categories