Answer / maddy

Multi join logical file is file joining more than two files. Keywords available with join logical files as as below:
JFILE - mandatory record level keyword giving files list to be joined
JOIN - mandatory join level keword only if more than two files are joined
JREF - reference to the file in joined file when a field in join logical file is not unique among the two files
JDFTVAL - optional to be used when one wants the primary file records are to be fetched even if secondary doesn't exist
JFLD - mandatory join level key word giving the join condition
JDUPSEQ - optional keyword when there are duplicate join fields are present to give the order

Answer / s.kumar

Keywords for Join logical file..
JDFTVAl(File Lavel Keyword)
JFILE (*Record format lavel Kewword)
JOIN (*Record format lavel Kewword)
JFLD (*Record format lavel Kewword)
JREF (*Field lavel Keyword)
JDUPSEQ (Field lavel Keyword)

* Manadatary Keyword

What is the use of L specs in RPG?

1 Answers  

---

when should I use method get, and when should I use method post in my cgis?

0 Answers   IBM,

---

What is the symbol used for shifting fields in SDA?

1 Answers  

---

how many printer files can be defined in f specs ?

1 Answers   IBM,

---

how can I start a page in a new window?

0 Answers   IBM,

---

Q.How primary file can be defined in RPG/400?Please write the senario with opcode specification?

3 Answers   Keane India Ltd,

---

how will you display a particular page in subfile ?

1 Answers   IBM,

---

What are the steps to retrieve the records from Journal file...?

1 Answers  

---

load all subfile logic in sqlrpgle and when updating particular record it must be lock form other jobs (not a file)?

1 Answers   Wipro,

---

what is lokup opcode?

1 Answers   IBM,

---

what is the necessary keyword for non-join logical file?

1 Answers   IBM,

---

Want to know related Interview questions and answers for seniors

1 Answers  

---