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 ....?
- 13 Answers
- 17500 Views
- Mind Tree, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / swetha p rao
Using Extmbr key word in F Spec you can access the members
of file in RPG4.
| Is This Answer Correct ? | 9 Yes | 1 No |
Answer / 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 |
Answer / sweta
What is the scenario exactly , You want to access all the
members of the file one by one and you donno the names of
the memebers
or
You want to access only second member and you donno the
name of the member
If you want to use only second number then define a
variable and initialise it with second member name.and in F
spec define the extmbr.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / samul
Sweta,
I think above scenario will clear what am trying to ask.
---------------------------
I have following scenario :-
a) One file says FILEA,has a three members
Members : Mem01 ,Mem02 ,Mem03
b) I want to use member Mem02 in my RPG400 program
(PGM01). (I have to use only RPG400 not RPGIV/RPGILE)
c) I don't want to use QCMDEXE,EXTMBR or OVRDBF in program
PGM01.
How can I do it....?
---------------------------
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / ravi
Small correction
1)create a logical file on the P.F.,while creating mention
the DataMember name in the CRTLF 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 ? | 1 Yes | 0 No |
Answer / shruti tayal
IGNORE/INCLUDE keywords are specific to all the record
formats of the member under consideration...so if used it
would ignore/include that specific record format not file
member.
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / samul
I stuck in this scenario.
Welcome to all of you for the suggestion
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / ankush chaudhary
Hi Paul,
In order to ignore say first member of a file and use the
2nd member we can use IGNORE and INCLUDE keywords on the F
specs.
IGNORE is used in case we do not want to use a particular
member of a file.
INCLUDE helps in using a particular record format for the
file.
Hope this clarify your doubt.
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / srinath
In F Spec use Keyword EXTMBR(Second member name)
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / swetha p rao
If we can use SQLRPGLE we can ccreate alias on the member.
I am not sure of other ways other than extmbr, Ovrdbf in
RPG400.may be you can tell me of there any other ways
| Is This Answer Correct ? | 0 Yes | 1 No |
What is the purpose of reorganizing the physical file i.e. , RGZPFM?
what is the sequence when using cursor?
can we use ASCII ,CDUP,SENDPASV commands in SFTP?
What controls which printer a report goes to?
What are Control level indicators?
describe the difference between the dowxx and douxx operations?
how many levels are there in a physical file?
how a varible can be passed to a subfile...accnt1 contain data in a data area..ie Daccnt1 uds,Daccnt2 3 overlay(accnt1:1), DNo 4 overlay(accnt1:4)..we want to transfer this dataarea value from acnt0001 to a subfile..that means to enter each record we have to incriment account no,, i normal window we can do move accnt1 account_no eval account_no=accnt1 eval no=no+1 exfmt usr_account how it possible with Subfile????????.Please do answer? (Thank you for all your answers dear friends!!)
what is the purpose of DMPCLPGM IN CL?
What is the purpose of the following I UDS I 1 60ORDER# I 7 90LINE#
what are the three line types in rlu ?
What Is Default Data Type (if You Define Decimals '0') In Physical File?
RPG400 
