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
- 12292 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 |
What is the native language of AS/400?
i have two pfs it contains "Status" fields in the same name "status in both the pf's...But i used the same name in display file...when i enter a status thru disp file it willbe added to pf1...so i want to rename "Staus " field in pf2 through program...............wat will do..give coding?
What are the types of Signature validation?
Q.How primary file can be defined in RPG/400?Please write the senario with opcode specification?
Describe the function of SETGT operation in RPG language?
What are the types of data structure in as400?
how do you use commitment control in rpg program ?
what are various techniques to pass parameters from one program to another?
How do I release jobs in queue and change a job destination to a different printer. I know wrkjobq but I have not worked with As/400 for a while,so_can someone help me?
How do you grant authority?
I have a display file with mandatory fields. Is there anyway that i can highlight those fields to bring attention to the user? The same behavior that AS400 makes when we attempt to execute a command without completing all the required parameters. Note: I have used DSPATR(HI) or DPSATR(RI) and they have different behaviors. Thanks.
How to create an Access path in Synon/2E ?
RPG400 
