Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


what is multijoin logical file?
what are the keywords available in joinlogical file?
what are the mandatary keywords for joinlogical file?
explai the keywords?

Answers were Sorted based on User's Feedback



what is multijoin logical file? what are the keywords available in joinlogical file? what are the ..

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

what is multijoin logical file? what are the keywords available in joinlogical file? what are the ..

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

Is This Answer Correct ?    5 Yes 3 No

Post New Answer

More IBM AS400 AllOther Interview Questions

what does check opcode is used?

1 Answers   IBM,


is it possible, in the same cgi, to run more than one gethtml or gethtmlifs?

0 Answers   IBM,


how can see logical file based on which physical file and vice versa

1 Answers   IBM,


I am working in session1 ans session2. In session1 3 jobs are running. In session2 2 jobs are running. How many LDA and temporary files will be created?

3 Answers  


What is the use of OVRDBF ?

1 Answers  






What is Job description?

1 Answers  


What is the purpose of FRCDTA (Force Data) keyword?

1 Answers  


What is an ICF file?

1 Answers  


Define what the operation will do, the purpose of the result field and the purpose of *IN66? HI LO EQ C CALL 'CVTDAT' DTPRM 66

1 Answers  


What is the native language of AS/400?

1 Answers  


What is the maximum number of key fields allowed defining in a physical file?

1 Answers  


How many libraries can be there in library list ?

1 Answers  






Categories