What is the difference between regular logical file and join logical file?



What is the difference between regular logical file and join logical file?..

Answer / nitin trivedi

Regular logical file contains more than one record format.
Record format name in regular logical file should be same based on the physical file.
Join logical file contains only one record format.
Record format name in join logical file should be different.
Through logical file we can made changes in physical file.
Through join logical file we can't made changes in physical file.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More IBM AS400 AllOther Interview Questions

How to inner join more than 2 PFs in a CL program using OPNQRYF command?

1 Answers  


What is an Array Data Structure?

1 Answers  


What is the purpose of OVRDTA keyword ?

1 Answers  


OVRDBF FILE(xxx) TOFILE(libl/filename) share(*yes) In which scenario is share(*yes) used? could any one explain with an example?

3 Answers   IBM,


a program variable coded in an embedded sql statement is referred to as?

1 Answers   IBM,






The content of Physical file is as below: hfcftp wruquief SENDPASV 0 CDUP ASCII GET 01100901.CSV ramndk/ECP505.EC0110090 (REPLACE QUIT Thw above commands will get executed when we call STRTCPFTP from CL program.... Now if I want to use SFTP what can be the solution? plz reply in detail....Thank you for ny help... I m using RPG/ILERPG to download...

0 Answers  


what is the clp command to access a query/400?

1 Answers   IBM,


what is the use of UNIQUEUE KEY WORD? what is the difference between PFILE AND REF?

2 Answers  


Hey, What is the difference between SCAN,CHECK,XLATE OPCODES? please give me the answeres with example in real time senario?

1 Answers  


How do you read a subfile record which is in output mode?

3 Answers  


using dfu, user will be able to ___________ from physical file?

0 Answers   IBM,


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   HCL,


Categories