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

Suppose we have field reference file we were any changes that corresponding Physical file then what will Happen in field reference file??

5 Answers   IBM,

---

how to convert date format from one format to another i think in CL/400 its CVTDAT,Please tell in RPG/400 sir not in RPGILE

3 Answers   iGate,

---

how many key fields does cl required

1 Answers  

---

. How to know why the OPM job is in MSGWAIT state?..WHAT COULD BE THE REASON FOR it?

1 Answers   Wipro,

---

what is match field indicator?

1 Answers   IBM,

---

how does union file maintains record formats?

0 Answers   IBM,

---

What is a Device file?

1 Answers  

---

Can fields be concatenated INa logical file level?

1 Answers  

---

Difference Between Call & Sbmjob?

0 Answers   IBM,

---

What is a Join Logical File, Can it be used for Update ?

1 Answers  

---

What is the default value for the number of increment for the physical file?

1 Answers  

---

PGM QSH CMD('/QOpenSys/bin/sftp -b/home/test/myfile.txt serverUserID@server') ENDPGM In above example,what is content of myfile.txt ...Thanx

2 Answers  

---