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.

Why we are not able to perform insert delete and update operation in Join logical file?

0 Answers   IBM,

---

I have 1 rd in my flat file. say reord from 1 to 10 position : 'AS400NDB2400' I need to change the value from N to Y using SQL stmt ...How can I update this....?

5 Answers  

---

Describe about Query/400?

1 Answers  

---

Can you summarize the steps I have to go through in writing my first cgi?

0 Answers   IBM,

---

what is the difference between seton lr and retrn?

1 Answers   IBM,

---

Feedback about ELI Faridabad.

3 Answers   Eli India,

---

i have two pfs it contains "Status" fields in the same name "status in both the pf's...But i used the same name in display file...when i enter a status thru disp file it willbe added to pf1...so i want to rename "Staus " field in pf2 through program...............wat will do..give coding?

5 Answers   CTS,

---

Can be OVRDBF command mentioned after OPNQRYF command in CL?

1 Answers  

---

We have seen no of parameter list but If we mention like this 'CALL PROGNAME PLIST ' how to know No of parameter name of program ?

2 Answers   IBM,

---

how can see logical file based on which physical file and vice versa

1 Answers   IBM,

---

why we sometimes use same file name in FILE and TOFILE in OVRDBF and sometimes different??please tell

3 Answers  

---

Want to know related Interview questions and answers for seniors

1 Answers  

---