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
- 11776 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 |
when you are defining a flat file in your program in f specs which format will you specify?
what are the different types of variables available in cl?
How to trap errors in CL?
To Add A File To The 'file Selection' Option Of A Query, The Function Key To Be Pressed Is?
What is Spool file, Why is it required?
how can you specify no duplicate key?
what is sflinz and sflrna?
What is a Join Logical File, Can it be used for Update ?
Show 2 ways to convert a date from YYMMDD to MMDDYY (MULT operation not acceptable)
Can you use multi format LF in CL program?
How to debug a batch job when it is in messagewait(mswg) status. I know the steps for batch ebugging, but im confusing with when we submit any job for batch debug we put in held state. So here also do same thing or any other way?
how can I automatically refresh a web page?
RPG400 
