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 file information data structure(infds) in as400?

931


what is the favicon.ico request that my site receives now and then?

609


What Is The Difference Between Goto & Exsr?

1144


how to read database records without locking them?

1093


What is access path in as400?

812






what is service program?

580


How to convert a spool file to PDF file in AS400?

711


what is the purpose of indicators in rpg?

1030


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...

2153


define the purpose/use for sflrna?

970


how can I control the way a remote browser uses its cache?

580


where will control be passed after the execution of the *pssr subroutine if the factor2 of the endsr is blank ?

1084


different type of cursor?

617


what are the different commands used in rlu ?

1408


what if my system I runs with system value qccsid 65535?

599