Maximum how many fields we can create under a record format of PF?
Submitted by: AdministratorWe 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)
Submitted by: Administrator
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)
Submitted by: Administrator
Read Online IBM DB400 Job Interview Questions And Answers
Top IBM DB400 Questions
☺ | How to update physical file using logical file with example? |
☺ | Why Journalling is compulsory before Commitment Control? |
☺ | Why we create the Physical File Member? |
☺ | Last statement of any RPG pgm is LR? |
☺ | Maximum how many fields we can create under a record format of PF? |
Top Mainframe Technical Categories
☺ | IBM MainFrame Interview Questions. |
☺ | IBM AS400 Interview Questions. |
☺ | JCL Interview Questions. |
☺ | IMS DB Interview Questions. |
☺ | CICS Interview Questions. |