Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


can we concate fileds in physical file? If yes how can we
do?

Answers were Sorted based on User's Feedback



can we concate fileds in physical file? If yes how can we do?..

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

can we concate fileds in physical file? If yes how can we do?..

Answer / ramreddy

NO,CONCAT IS USED LF ONLY.WE CAN;T USE PF.

Is This Answer Correct ?    14 Yes 0 No

can we concate fileds in physical file? If yes how can we do?..

Answer / kumar vikas

Hello Radha,

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

can we concate fileds in physical file? If yes how can we do?..

Answer / radha sammangi

00010A R RECORD2 PFILE(PF1)
00020A DATE CONCAT(MTH DAY YEAR)
00030A MTH
00040A DAY
00050A YEAR


Radha

Is This Answer Correct ?    4 Yes 4 No

can we concate fileds in physical file? If yes how can we do?..

Answer / karu

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:
they are
joining date and
name
and dept...

Is This Answer Correct ?    0 Yes 0 No

Post New Answer



More DB400 Interview Questions

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

3 Answers  


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?

2 Answers  


WHAT IS THE DIFFERENCE BETWEEN 'COLHDG' AND 'ALIAS'?

5 Answers   Accenture,


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?

0 Answers  


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 ?

4 Answers  






one physical file can have how many max of logical files? what is the primary file?

3 Answers   Four soft,


Last statement of any rpg program is lr?

0 Answers  


A pf containing 100 records... my query is how to display from 11th record in the pf?

3 Answers  


What is the primary file?

0 Answers  


What is the purpose of the chain and setll and setgt?

0 Answers  


How to retrieve a physical file after deleting that?

0 Answers  


How to add a field to a PF and compile it without loss of data?

6 Answers  






Categories