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

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What Is Ddm ?

1038


what are various techniques to pass parameters from one program to another?

1048


what is the purpose of data structure?

1010


Can any one explain the basic things about RLU and Printer Files and their Definitions for both and why are they used,i'm a newbee so please help me out

2904


how do you know that records are locked?

1162






How can we change the uppercase to Lowercase in RPG?

933


what is sflrolval?

652


define the purpose of the *bcat function?

914


what does vldcmdkey means?

819


what is the sequence when using cursor?

607


Hi,Please give me the the answer for these quesitons? 1.what is IFS and ICF and RAPE amd DISKET fils? explain with example please? 2.What is the difference between POST AND SPACE OPCODES? 3.Can anybody tell me default printerfile command and object type?

2087


how you will find an error which is not in the first page of the subfile without using rolldown key?

562


Difference between NOPASS & OMIT?

1195


what is the maximum number of files allowed in rpg?

942


Apart from opening of a file do we have any other use of USROPN?

960