I had ruestion in one of the interview.....
If 1 file has more than 1 member and i want to use the 2nd
member in the RPG pgm (in RPG400),how can I use this....
I know the possible answers i.e. useing API 'QCMDEXE' or
Before calling the pgm I can use OVRDBF for that member...
but I dont' want to use both the tips in above scenarion.
Does any body tell me how can i use this ....?
Answer Posted / suresh kumar
1)create a logical file on the P.F while creating mentioned
the DataMember name in the crtpf command and use this
logical if u are not able to use ovrdbf in cl, Extmber in
RPG400/RPGIV and QCMDEXEC in RPG/RPGLE to Execute in OVRDBF.
ex: CRTLF FILE(FILEA) DTAMBRS((FILEA (MEM02)))
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
how do you know that records are locked?
how you will know whether you are in sfldrop or sflfold mode?
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.
what are the uses of factor1, factor2 and result field for the rpg operation code parm?
How to debug a batch job when it is in messagewait(mswg) status. I know the steps for batch ebugging, but im confusing with when we submit any job for batch debug we put in held state. So here also do same thing or any other way?
what is the purpose of the indara keyword?
What is the use of jdftval in as400?
what is the length of a variable in rpg?
when are the unique constraints executed?
How can we read file using curser? how to define a curser?
WHICH REPLY CODE IS USED BT sftp ? ... (e.g.226 is used by FTP IF FILE IS TRANSFERED)
What is the as400 called now?
what is the use of jdftval in join logical file?
which are the query selection criteria, which can be given in a query?
What Is The Object Type Of Pf, Lf, Printer File & Display File?