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

how can i know logical file belongs to which physical file without source?

3 Answers   Cap Gemini,


If we use the file level keywords like LIFO, FIFO, FCFO in a file, can we see the impact of it by doing the run query of the file? if not how can we see the impact of these keywords.

2 Answers  


wirte a simple program for read file in cl

2 Answers   Active Brains,


Define interactive jobs and batch jobs

6 Answers  


can any one pls tell me some differences between a LF and command OPNQRYF?

3 Answers   Accenture, Cognizant, eFunds,






How can we know that a trigger has been added on a PF? and what is the purpose of adding a trigger?

3 Answers  


Can anybody tell why Journalling is compulsary before Commitment Control?

2 Answers  


How we can't update join logical files?

10 Answers  


how can we write LF using flatfile.

9 Answers  


How to retrieve a physical file after deleting that ? what is keyword used for that....??

6 Answers  


Maximum how many fields we can create under a record format of PF?

5 Answers  


I have a PF with out any data but the dependent LF is having data?

1 Answers   HCL,


Categories