Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> MainFrame >> IBM AS400 >> DB400
  2. Suggest New Category

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

Question Posted / as400.mohan

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

When we create a pf and did not fill up maint parameter, then by default which access path will the system take & why?

0 Answers  

how can we write LF using flatfile.

9 Answers  

Hi, Please give the answer to this question? I have Phisical file with 100 records,there is no any duplicate records in this pf.Based on this pf one Logical file i have used.But this lf is viewing only 80 records only of that pf?What is the reason for this?Please give me answer?

4 Answers   IBM,

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

3 Answers  

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

5 Answers   Infosys,

I have physical file with 100 records,there is no any duplicate records in this pf.based on this pf one logical file I have used.but this lf is viewing only 80 records only of that pf?what is the reason for this?

0 Answers  

How to read a PF in reverse(from last rec to first) using CL?

3 Answers   HCL,

Suppose I have a pf, it contains 5 members, how to access particular member data from logical file? What is the use of member in pf?

0 Answers  

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

4 Answers   HSBC,

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  

what is multiple member pf

1 Answers   Active Brains,

How to find the list of source physical files in a library?

0 Answers  

For more DB400 Interview Questions Click Here
Categories