Interested to Buy Any Domain ? << Click Here >> for more details...
Q. HOw can read multimember file through RPG/400 and CL/400
Actully i know that we can Read multimember file in RPG
through EXEFILE and EXEMBR and in cl through OVRDBF and
MEMBER(3)....But i want to read 3 members by CL Program And
RPG/400 program.Please write the coding(Program) for both
RPG/400 and CL/400 programs?
2.What are the full forms(stands) of EXEFILE and EXEMBR?
- 5 Answers
- 33342 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / abhishek bajpai
To read a multi member file.. u only need EXTMBR.
EXTFILE is used so that the name of the file is verified at
runtime and not at compile time. It is also used so that
the program opens the file from a desired library only (by
giving qualified name of the file as the parameter) and
not from the library list as usual.
To read the 3 members of a file..u must know the name of
the 3 members. On the F spec define the file with
EXTMBR(VAR1) USROPN
where Var1 is a variable. Before opening the file populate
Var1 with the member name in caps. And read the file.
In CL use OVRDBF as usual with the member name.
| Is This Answer Correct ? | 24 Yes | 4 No |
Post New Answer View All Answers
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.
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...
what is logical file?
What is binder language ?
Pose, there are 100 records in the file.i need to retrieve all the records matching/equal to the particular name field. How can we do the above using search criteria other than using the if cond?
maximum number of subfiles that can defined in a rpg program for one display file is?
why do we use readc? What is sflnxtchg?
how can you detect and handle a record lock situation?
how do u compile rpgle program?
define the purpose of the *bcat function?
define what a data area is along with a brief example of what it may be used for?
what do we can do with the embedded sql statements?
Apart from opening of a file do we have any other use of USROPN?
what is the command to know key fields of file?
is there any way I can ease my rpg controls on numeric input fields? How about an input date field?
