Answer Posted / 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 View All Answers
what is the difference between *like and *namvar ?
define the purpose of the *bcat function?
what is match field indicator?
What is the difference between non-join logical files and join logical files?
what is the use of jdftval in join logical file?
how can a message from a message file appear as a constant on the screen?
can you specify a display file to be used in the following modes input,output, or combined modes ?
what are dds required for subfile?
What is array in as400? What are the types of array?
in conjunction with what other keyword must ovrdta and ovrata be used?
what does opcode post do ?
what are all the contents of subfile?
what is the maximum number of subroutines allowed in rpg?
when are the referential constraints executed?
how can I predict the performance of my cgis?