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
What is file information data structure(infds) in as400?
what is the favicon.ico request that my site receives now and then?
What Is The Difference Between Goto & Exsr?
how to read database records without locking them?
What is access path in as400?
what is service program?
How to convert a spool file to PDF file in AS400?
what is the purpose of indicators in rpg?
If I want to execute Sftp commands(LS & GET) stored in Physical file from CL program automatically...Can u Plz tell me how can I do this?...How the script will look?? THANX FOR NY HELP...
define the purpose/use for sflrna?
how can I control the way a remote browser uses its cache?
where will control be passed after the execution of the *pssr subroutine if the factor2 of the endsr is blank ?
different type of cursor?
what are the different commands used in rlu ?
what if my system I runs with system value qccsid 65535?