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

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

0 Answers  


Define interactive jobs and batch jobs

6 Answers  


Why we create the Physical File Member?

5 Answers  


Is it possible to create a logical file whose Physical file is not in same library?

6 Answers  


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  






Suppose if a physical file is having 1000 records, but i deleted 500 records from it. Here the concern is can the size of the file changes or it remains the same... kindly help me out with thorough xplanation.... Thanks in-advance...

6 Answers   ABC, TCS,


In how many ways we can create a logical file?`

5 Answers  


how to add a new field to a file without compiling it?

1 Answers  


what is the purpus of the chain and setll and setgt ?

2 Answers   Four soft,


There is one string as A B C and wanted to display string as Shri A Shri B Shri C, how we can do this in sql? If we have around 100 values in string like this, each value should be displayed with initials as Shri.

0 Answers  


how can we write LF using flatfile.

9 Answers  


Q.1 how to implement the commitment control. 2.how to control commitment control from external program.

7 Answers   IBM,


Categories