1.What is the difference between regular join logical file
and non join logical file?
2.what are the nessasary keywords for non join logical file
- 3 Answers
- 13767 Views
- ANZ, I also Faced
- E-Mail Answers
Answer Posted / s. kumar
Answer1:
More than one Database file can be joined by different ways
like..
1)Inner join or Join Logical file
2)Left outer Loin
3)Right outer Join
4)Self join
These all are join logical file.
Non Join Logical file means Simple Logical file i.e Only
one PF file.
Answer2:
PFILE is the necessary keyword for non
join logical file.
R Rec-For PFILE(PF name)
| Is This Answer Correct ? | 20 Yes | 0 No |
Post New Answer View All Answers
can a indexed file be accessed in arrival sequence in rpg program?
How can we change the uppercase to Lowercase in RPG?
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...
define subsystem?
is it possible, in the same cgi, to run more than one gethtml or gethtmlifs?
what is the maximum number of records you can specify in a display file?
what is a non-join logical file?
Difference Between Source Physical File & Physical File?
where will control be passed after the execution of the *pssr subroutine if the factor2 of the endsr is blank ?
what are the three types of keywords associated with printer file ?
what would be the effect on the field where reverse image, underline and highlight display attributes are active ?
can a join logical file be updated?
What is the use of jdftval in as400?
how will you search an array?
name few ibm supplied libraries?
