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

What is the interactive job? What is the batch job?

0 Answers  


YOU CAN DELETE THE RECORD SPACE PERMENANTLY IN PHYSICALFILE THROUGH CL?

4 Answers  


How to know the perticular record in pf with out reading?

2 Answers   Cap Gemini,


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

0 Answers  


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

5 Answers  






what is general and type of general

1 Answers   Active Brains,


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

6 Answers   HSBC,


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

0 Answers  


How we can't update join logical files?

10 Answers  


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

2 Answers   Four soft,


How to know the particular record in pf with out reading?

0 Answers  


how to restrict upon adding the data for field reference file in DB400

1 Answers  


Categories