what is multijoin logical file?
what are the keywords available in joinlogical file?
what are the mandatary keywords for joinlogical file?
explai the keywords?
- 2 Answers
- 11217 Views
- HCL, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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
| Is This Answer Correct ? | 8 Yes | 0 No |
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
| Is This Answer Correct ? | 5 Yes | 3 No |
What is SAA?
how do you use exceptional write in c specs?
what is the main use of OPNQRYF ?? in that query why we can use OVERDBF and in that OVERDBY why should we use SHARE(*YES)
What is Job description?
a program variable coded in an embedded sql statement is referred to as?
What are the types of Signature validation?
What is Data Area?
how can see logical file based on which physical file and vice versa
How to read data from *LDA (Local Data Area) in RPGLE program without using IN opcode?
how many triggers can be associated with a file?
What is the purpose of the following C/COPY QRPGSRC, ORDERR
What is the Function of PDM?
RPG400 
