How to inner join more than 2 PFs in a CL program using
OPNQRYF command?
- 1 Answers
- 5512 Views
- I also Faced
- E-Mail Answers
Answer / omer ozen
You don't. OPNQRYF is an abomination. Don't use it and use
a proper language to do your programming.
| Is This Answer Correct ? | 0 Yes | 0 No |
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...
How to write a password mask program in as400? like the password which i type should be displayed as '*****' r ###### which the user wishes to dispaly if u could help me with url r the solution in written code this will help me
what is the purpose of indicators in rpg?
What is the use of Data Queues?
When would the ALL keyword be used?
How can we arrange duplicate records in a file?
What is an Array Data Structure?
what is command in SFTP which is equivalent to SDUP command in FTP?
What is the maximum number of elements in an array?
what is the sequence when using cursor?
Q. 1.What are the in build functions in CL program and what are uses of thes in build functions? 2.How we can create own command in CL program? 3.What is use of STRSRVJOB?
i am using non join multiple format my 3 database file is like that pf97 R REC ENAME ETENNO ESTATUS K ENAME pf98 R REC1 ENAME ESAL K ENAME PF99 R REC3 ENAME CRDCARD EID K EID & MY NON JOIN LOGICAL FILE IS ALSO SAME EXCEPT RECORD NAMES BEFORE I TRIED WITH 2 FILES SO ITS SAYS ERROR I.E.(Key field attributes must be same as for previous formats. ) SO I CHANGED KEYFIELD ACCORDING TO PF SO ITS WORKING BUT AFTER ADDING 3 FILES ITS SAYING SAME ERROR . I DONT KNOW I NEW IN AS400 PLLZ HELP ME I HAVE ONE MORE QUE. CANT BE USE DIFFERENT KEYFIELD (NOT ACCORDING TO PF) IN NON JOIN LOGICAL FILE.
RPG400 
