Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 12388 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 |
all i need to know about cmpseqdat parameter in cmppfm, how it works and can we retrieve line sequence and date from the output?
Why we are not able to perform insert delete and update operation in Join logical file?
Q. 1.What would be structure of CL PGM. 2. What are the levels of CL PGM. 3.How many files can be defined in new CLLE program?
1. There is a file called Month. Month has 12 members called Jan, Feb, ..., Dec. How to design a rpg code which can access any member and show its content. (User can ask for any member when required)?
what is lokup opcode?
what are necessary keywords to code message subfile?
what opcode will be used to test the zone of a character field?
what is flatfile?what is the use of this file?where we can use usualy?what is the advantage of this?
How can we change the uppercase to Lowercase in RPG?
Difference between NOPASS & OMIT?
What are all the compiler directive statements?
how to develop some simple graphs (bar charts) using just html?
RPG400 
