1.

Maximum How Many Fields We Can Create Under A Record Format Of Pf?

Answer»

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)

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.


Discussion

No Comment Found

Related InterviewSolutions