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

Answers were Sorted based on User's Feedback



i have a PF,it contains 5 members,how to access particular member data from logical file ?and what ..

Answer / syam

A1. Reading member 5 of myfilepf
CRTLF FILE(KCS/MYFILELF) SRCFILE(KCS/KC1) DTAMBRS
((KCS/MYFILEPF (MBR5)))
Or
ADDLFM FILE(KCS/MYFILELF) MBR(MYFILEBR) DTAMBRS
((KCS/MYFILEPF (MBR5)))

A2.For accounting purpose each month data can be stored as
12 different members.
So that we can easily access one month data or 12 months
together.
Easy to maintain 12 members in one PF file instead of 12 PF
Files.

Is This Answer Correct ?    17 Yes 0 No

i have a PF,it contains 5 members,how to access particular member data from logical file ?and what ..

Answer / pravin

By using OVRDBF (Override with Data Base File).We can
access particular member of file.

Is This Answer Correct ?    6 Yes 4 No

i have a PF,it contains 5 members,how to access particular member data from logical file ?and what ..

Answer / malli

(Q)u have a pf & it contain 5 members

(A) u can enter wrkmbrpdm --file name then

dspf--filename

Is This Answer Correct ?    2 Yes 10 No

Post New Answer

More DB400 Interview Questions

Last statement of any RPG pgm is LR?

5 Answers  


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

5 Answers   Accenture,


what is the difference between adding keys & constraints into a phisical file

4 Answers   HSBC,


What is the batch job?

0 Answers  


what is the intractive job? what is the batch job ? how to change the batch job to interactive job?

2 Answers   Four soft,






What is open data path?

0 Answers  


what is open data path? and what is the diff b/w access path and open data path?

3 Answers   Cap Gemini,


CRTDTA AND CRTARA should be used along with?

2 Answers  


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

3 Answers  


YOU CAN DELETE THE RECORD SPACE PERMENANTLY IN PHYSICALFILE THROUGH CL?

4 Answers  


How to find the list of source physical files in a library?? Is there any way to get a list??

5 Answers   Infosys,


Which keyword is used both in subfile and subfile control record format of a DSPF?

8 Answers  


Categories