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

Is Constent can be define as a key field?

3 Answers  


How to retrieve a physical file after deleting that ? what is keyword used for that....??

6 Answers  


When we use any keyword like FIFO,LIFO, at file level but whenever we check by runqry we couldn't find answer in FIFO,LIFO,FCFO etc so how we check the answer.

2 Answers  


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

1 Answers  


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

4 Answers  






one physical file can have how many max of logical files? what is the primary file?

3 Answers   Four soft,


How to update physical file using logical file with example?

0 Answers  


Why journalling is compulsory before commitment control?

1 Answers  


what is error handling concepts in cl

3 Answers   Active Brains,


Last statement of any rpg program is lr?

0 Answers  


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

0 Answers  


How we can't update join logical files?

10 Answers  


Categories