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

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

1 Answers  

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  

In a CL Program after executing a SQL SP how to receive a Output value from the SP. Just to make it clear I am sending 2 input and 1 output parameter to the SQL Stored Procedure. Now while receiving it output parm it is failing.

0 Answers   Nous,

How to retrieve a physical file after deleting that?

0 Answers  

what is use of self join and which cases you will use this join

1 Answers   TCS,

Define interactive jobs and batch jobs

6 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,

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

5 Answers  

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

7 Answers   IBM,

how to update physical file using logucal file with example

1 Answers   Wipro,

What is FORMAT keyword and its use?

0 Answers  

what is exception and how many types of exception

1 Answers   Active Brains,

For more DB400 Interview Questions Click Here
Categories