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 |
What is the purpose of the following? I 'CLOSED' C STAT01 I 'OPEN' C STAT02
What is library is as400? What are the types of library?
what is the function of cpysplf command?
Which command we can use to update a physical file using c.l pgm?
How to create an Access path in Synon/2E ?
How many secondary files allowed in a program?
what are various techniques to pass parameters from one program to another?
can I copy content of Physican file in some source Member of type TXT? Thanx..
How can we arrange duplicate records in a file?
What is a query can be displayed without saving it?
can you display a empty subfile?
What is FCFO, FIFO, LIFO in Database environment ?