can we concate fileds in physical file? If yes how can we
Answers were Sorted based on User's Feedback
Answer / kumar vikas
No, we cannot concat fields in Physical File. However, in
logical file, we can concat 2 or more fields together into 1
field. format is..
name concat(fname mname lname)
|Is This Answer Correct ?||31 Yes||0 No|
Answer / ramreddy
NO,CONCAT IS USED LF ONLY.WE CAN;T USE PF.
|Is This Answer Correct ?||14 Yes||0 No|
Answer / kumar vikas
wat u r explaining here is a LF... the question was for a PF if fields can be concatenated in a PF. Ur answer is correct but for PF, fields cannot b concatenated.
|Is This Answer Correct ?||5 Yes||0 No|
Answer / radha sammangi
00010A R RECORD2 PFILE(PF1)
00020A DATE CONCAT(MTH DAY YEAR)
|Is This Answer Correct ?||4 Yes||4 No|
no...concatenation of two/more fields in pf not possible...
if you want to do it...it can be possible with the help of lf(logical file)
example: eid concat(jdate name dept)
here eid created with
3 other fields:
joining date and
|Is This Answer Correct ?||0 Yes||0 No|
i have a PF,it contains 5 members,how to access particular member data from logical file ?and what is the use of member in PF
Where the QTEMP library will get created? if the the answer is QSYS, then howcome more than one job can create same library name(QTEMP) in QSYS? what is the uniqueness of QTEMP? For example, run the below command in different workstation WRKOBJ QSYS/QTEMP And take 8 in the option to check the description. both will have different info. so where(which LIB) exactly the QTEMP is stored?
WHAT IS THE DIFFERENCE BETWEEN 'COLHDG' AND 'ALIAS'?
Suppose I have a pf,it contains 5 members,how to access particular member data from logical file ?and what is the use of member in pf?
How can i retrieve city while my i have one field address length 60 but i don't know what where is city in this field ?
one physical file can have how many max of logical files? what is the primary file?
Last statement of any rpg program is lr?
A pf containing 100 records... my query is how to display from 11th record in the pf?
What is the primary file?
What is the purpose of the chain and setll and setgt?
How to retrieve a physical file after deleting that?
How to add a field to a PF and compile it without loss of data?