Diff B/w ref and reffld?



Diff B/w ref and reffld?..

Answer / anonymous- projo

REF and REFFLD are keywords that can be used in DDS during
creation of physical files.
The following are the differences

1. Ref is a file level keyword - Reffld is a field level
key word.
2. Ref is used to refer to a field reference file and we
write field reference file as its argument. With this we
can bring attributes and keywords defined in FRF intto the
DDS we are defining. This requires R in the REF column of
the Field in the DDS.
Reffld when used also requires R in the Ref column of DDS
and this can draw attributes and keywords that are already
defined in amy file and any field. The file name and the
field name are mentioned as arguments to this keyword.
3. Both can be freely used within the same DDS if needed.
4. These keywords help only at file creation time and has
no impact when the file referenced is changed at later
time.

Is This Answer Correct ?    9 Yes 1 No

Post New Answer

More IBM AS400 AllOther Interview Questions

What is the purpose of the following? I 'CLOSED' C STAT01 I 'OPEN' C STAT02

1 Answers  


What is library is as400? What are the types of library?

1 Answers  


what is the function of cpysplf command?

1 Answers   IBM,


Which command we can use to update a physical file using c.l pgm?

19 Answers   Ocwen,


How to create an Access path in Synon/2E ?

1 Answers  






How many secondary files allowed in a program?

1 Answers  


what are various techniques to pass parameters from one program to another?

1 Answers   IBM,


can I copy content of Physican file in some source Member of type TXT? Thanx..

1 Answers  


How can we arrange duplicate records in a file?

0 Answers  


What is a query can be displayed without saving it?

0 Answers   IBM,


can you display a empty subfile?

0 Answers   IBM,


What is FCFO, FIFO, LIFO in Database environment ?

1 Answers  


Categories