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 update physical files using normal logical file

4 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,


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

3 Answers  


How many maximum record format a logical file have?

0 Answers  


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

1 Answers   TCS,






I had created one physical file tell me command to enter data in to?

1 Answers  


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

1 Answers  


How to add a field to a PF and compile it without loss of data?

7 Answers  


what is open data path? and what is the diff b/w access path and open data path?

3 Answers   Cap Gemini,


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

1 Answers  


When we create a pf and did not fill up maint parameter, then by default which access path will the system take & why?

0 Answers  


how to know total no of records in pf with out using sql??????

3 Answers  


Categories