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


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

Answers were Sorted based on User's Feedback



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

Answer / perfect

We can give max of 8000 fields after rec format of a PF

Is This Answer Correct ?    26 Yes 0 No

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

Answer / ravi shankar porwal

We can give max of 8000 fields in rec format of a PF.But it
also depend on the no. of bytes occupied by the record
formate.Because rec. format of PF may occupy atmax 32766
bytes.ie if there is only one field which occupy 32766
bytes then we can't define a new field in record format.
so it depend on the no. of bytes occupied by the field
defined in the record format.
Ex.
Char field - max value(32766 bytes)
variable length field - max value(32740 bytes)
allow null field - max value(32765)
variable & allownull field - max value(32739)

Is This Answer Correct ?    9 Yes 0 No

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

Answer / manchu.s

8000

Is This Answer Correct ?    8 Yes 0 No

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

Answer / sunil kumar

8000 only

Is This Answer Correct ?    3 Yes 0 No

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

Answer / viney

a max. of 8000 fields can be added in a physical file... a
single pf can have a max of 32 rec. fmts defined in it.

Is This Answer Correct ?    1 Yes 10 No

Post New Answer

More DB400 Interview Questions

I had created one physical file tell me command to enter data in to?

1 Answers  


what is general and type of general

1 Answers   Active Brains,


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

0 Answers  


What is the primary file?

0 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  


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,


There are six records in a file and we are going to update that records and used commit operation when it complete the update but suppose when it updating the third record,a error occured and operation failed.Is previously two records will be update or whole operation will be rollback? Please confirm it.

2 Answers  


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

1 Answers   TCS,


I want to change the attribute of field or want to add new field in existing PF but condition is format level identifier should not change, is it possible?

9 Answers   Mind Tree, TCS,


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,


How to add a field to a PF and compile it without loss of data?

7 Answers  


How many max. Record format a logical file have?

13 Answers   Systime,


Categories