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 we can't update join logical files?

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


Can we concatenate fields in physical file? If yes how can we do?

0 Answers  


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

0 Answers  


What is the batch job?

0 Answers  






What is the interactive job?

0 Answers  


Is it possible to create a logical file whose Physical file is not in same library?

6 Answers  


How can we handle errors in RPG?

4 Answers  


what is error handling concepts in cl

3 Answers   Active Brains,


How to read a pf in reverse(from last record to first) using cl?

0 Answers  


There are six records in a file and we are going to update that records and used commit operation when it complete the update but suppose when it updating the third record,a error occured and operation failed.Is previously two records will be update or whole operation will be rollback? Please confirm it.

2 Answers  


How to read a PF in reverse(from last rec to first) using CL?

3 Answers   HCL,


Categories