ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
Do you have a collection of Interview Questions and interested to share with us!!
Please send that collection to along with your userid / name. ThanQ
Google
 
Categories  >>  Software  >>  MainFrame  >>  IBM AS400  >>  IBM AS400 AllOther
 
 


 

 
 RPG400 interview questions  RPG400 Interview Questions
 COBOL400 interview questions  COBOL400 Interview Questions
 DB400 interview questions  DB400 Interview Questions
 COOLPLEX interview questions  COOLPLEX Interview Questions
 IBM AS400 AllOther interview questions  IBM AS400 AllOther Interview Questions
Question 
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 ....?
 Question Submitted By :: Samul Paul
I also faced this Question!!     Rank Answer Posted By  
 
  Re: 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
# 1		 
Using Extmbr key word in F Spec you can access the members 
of file in RPG4.
 
Is This Answer Correct ?    2 Yes 0 No
Swetha P Rao
 
  Re: 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
# 2		 
Sweta yes, we can use EXTMBR in RPG4 but I need use RPG400 
only....
 
Is This Answer Correct ?    0 Yes 1 No
Samul Paul
 
 
 
  Re: 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
# 3		 
I dint get you. You define your member name and specify 
Extmbr in F spec.This is in RP400 only rite? we are not 
using anything else other than RPG400.
 
Is This Answer Correct ?    0 Yes 1 No
Swetha P Rao
 
  Re: 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
# 4		 
Hi Swetha,thanks for ur suggestion.

If I am not worng , in RPG400 pgm we can't specify 2nd 
member in F-spec.

Clear me if I am worng....

Thnaks
 
Is This Answer Correct ?    0 Yes 1 No
Samul Paul
 
  Re: 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
# 5		 
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 ?    0 Yes 0 No
Sweta
 
  Re: 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
# 6		 
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 ?    0 Yes 0 No
Samul
 
  Re: 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
# 7		 
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 0 No
Swetha P Rao
 
  Re: 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
# 8		 
I stuck in this scenario.

Welcome to all of you for the suggestion
 
Is This Answer Correct ?    0 Yes 0 No
Samul
 
  Re: 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
# 9		 
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 ?    0 Yes 0 No
Suresh Kumar
 
  Re: 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
# 10		 
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 ?    0 Yes 0 No
Ravi
 
  Re: 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
# 11		 
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 0 No
Ankush Chaudhary
 
  Re: 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
# 12		 
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 ?    0 Yes 0 No
Shruti Tayal
 

 
 
 
Other IBM AS400 AllOther Interview Questions
 
  Question Asked @ Answers
 
what is the use of CPYFRMQRYF?  2
WHICH COMMAND WE CAN USE TO UPDATE A PHYSICAL FILE USING C.L PGM? Ocwen12
how can we view the entire objects and its types in a pgm? Mind-Tree7
What is the difference between keys of a Physical file and the keys of a logical file? Bank-Of-America1
we have 2 PF files with same name, how to copy data's from one file to another through RPG program logic?  3
How can u create a temporary file in CLP @ how to access that temporary file in RPG program?  2
how we lock a pf???? what are the parameters used in this command.how we understand whether an object is locked or not?? using command .....we have to use *PSSR? and trough *status..how??.if we give an eg to me???pls answer me anyone.. CTS3
how to get no of records in file in rpg with out cl cmd iGate2
how can i convert hexadecimal value to packed value? CGI1
What are the steps to retrieve the records from Journal file...?  1
can u plz tell me is there any difference between SHELL SCRIPT & SFTP SCRIPT? I want to run LS & GET(automatically) command from CL program....which script can be used?  1
How to declare the length of emp no in the physilcal file and the mandatory length is 6 i.e. Emp No should be numeric, mandatory and fill all the 6 places  1
function of DSPPGMREF?  3
what is data structure?how many types of data structers?  1
PGM QSH CMD('/QOpenSys/bin/sftp -b/home/test/myfile.txt serverUserID@server') ENDPGM In above example,what is content of myfile.txt ...Thanx  1
Hi,while writing a program, what is the mandatory specification using rpg/400 (in7 specification)?And please tell me what is the difference between SCAN AND CHECK opcodes?can any body tell me in real time senario?with example?  2
what is the rpg and cl life cycle?Please tell me any body  1
Can anybody please tell me what is difference between SQL (STRSQL ) and WRKQRY .....?  2
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? CTS4
What is the benefit of using Externally Described files over Internally Described? Patni17
 
For more IBM AS400 AllOther Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us |   interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com