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
- 11166 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 |
how many files can be defined in f specs?
What is GDA?
what is the disadvantage of using global variable?
What is the purpose of OPNQRYF (Open Query File)?
what the purpose of ovrdta, ovrata keywords?
What is the function of RJE Conversion Utility?
What is the purpose of the following C/COPY QRPGSRC, ORDERR
which of the following operations does not zero the field flda defined as 4,0?
what is rpg fixed logic cycle?
what is the purpose of the indara keyword?
how many triggers can be associated with a file?
How many secondary files allowed in a program?
RPG400 
