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 eliminate the level check error

2 Answers   TCS,


Where the QTEMP library will get created? if the the answer is QSYS, then howcome more than one job can create same library name(QTEMP) in QSYS? what is the uniqueness of QTEMP? For example, run the below command in different workstation WRKOBJ QSYS/QTEMP And take 8 in the option to check the description. both will have different info. so where(which LIB) exactly the QTEMP is stored?

2 Answers  


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

1 Answers  


wirte a simple program for read file in cl

2 Answers   Active Brains,


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

3 Answers   HCL,


How we can't update join logical files?

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


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

3 Answers   Cap Gemini,


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

0 Answers  


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

0 Answers  


Can anybody tell why Journalling is compulsary before Commitment Control?

2 Answers  


i have a PF,it contains 5 members,how to access particular member data from logical file ?and what is the use of member in PF

3 Answers  


Categories