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...


Why we create the Physical File Member?

Answers were Sorted based on User's Feedback



Why we create the Physical File Member?..

Answer / kolla ravi

A member is like an Individual file.It is possible to Have
32767 such members within the same PF.Each member added to
the file will exactly get the same record format(
fields,types and KWDS) on the file.This facility is
provided to meet the requirement when many files are needed
to be created with same structure.Here just Create file
once with MAXMBRS(as many reqd) and ADDPFM will do it.Easy
to create and maintain as a single object.Each member is
identified by unique name within file.
Examples : A School has attendance register per class. Each
Class has 4 sections and in all10 classes. Instead of
Creating and maintaining 40 files and scaterred in a
library, one can create a PF and add 40 members in one
object.
Secondly All Physical files created need not necessarily
have members. Some files are created to store field
definitons only and are called field refrence files. They
need not have members.

Is This Answer Correct ?    23 Yes 2 No

Why we create the Physical File Member?..

Answer / samul

MEMBER IS USE TO STORE THE DATA, EACH FILE MUST HAVE MEMBER.

Is This Answer Correct ?    12 Yes 7 No

Why we create the Physical File Member?..

Answer / sethu 400

know about the as 400 hierarchy

library
source member
source file
source data
(r) source statement


source members are created to to distinguish the souces of
diffesent database file, cobol,cl and dds. All these are
due to the as 400 architecture

Is This Answer Correct ?    1 Yes 3 No

Why we create the Physical File Member?..

Answer / nitish

source members are created to to distinguish the souces of
diffesent database file, cobol,cl and dds. All these are
due to the as 400 architecture

Is This Answer Correct ?    0 Yes 2 No

Why we create the Physical File Member?..

Answer / chandu

bcz each seeker work in wrkmbrpdm in that must have create
pf bcz

it stores data upto 36767 members in one file&lib

mainly it contain to store data

Is This Answer Correct ?    1 Yes 4 No

Post New Answer

More DB400 Interview Questions

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

2 Answers   Four soft,


Why journalling is compulsory before commitment control?

1 Answers  


1. How can I create a LF using crtlf command based on a particular member in a multimember PF? Where I have to specify the member name? 2. How to differentiate between the types of join from a Join logical file DDS. Is it possible to have different types of Join Logical files? 3.Any performance difference between Opnqrf and Embedded SQL? When I should prefer Opnqryf and when SQL? 4. I know access path is the path chosen by the program to retrieve data. It can be of keyed access path or arrival sequence. *IMMED- *IMMED description says access path is updated each time record is added or deleted from a member. - What is updating here? *REBLD - The access path is completely rebuilt each time a file member is opened. The access path is maintained until the member is closed, then the access path is deleted. - I am not able to understand this completely. Could anyone explain these more clearly? 5.What is the purpose of using activation group. I know it is a resource allocator, but other than this any other benefits of using an activation group?

2 Answers   IBM,


what is multiple member pf

1 Answers   Active Brains,


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

1 Answers  


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

5 Answers  


Last statement of any rpg program is lr?

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


Can we concatenate fields in physical file? If yes how can we do?

0 Answers  


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

3 Answers   Cap Gemini,


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,


Where the QTEMP library will get created? if the the answer is QSYS, then howcome more than one job can create same library name(QTEMP) in QSYS? what is the uniqueness of QTEMP? For example, run the below command in different workstation WRKOBJ QSYS/QTEMP And take 8 in the option to check the description. both will have different info. so where(which LIB) exactly the QTEMP is stored?

2 Answers  


Categories