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

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is open data path?

581


What is the primary file?

586


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

588


Last statement of any rpg program is lr?

614


How to change the batch job to interactive job?

578






What is the difference between access path and open data path?

596


In a CL Program after executing a SQL SP how to receive a Output value from the SP. Just to make it clear I am sending 2 input and 1 output parameter to the SQL Stored Procedure. Now while receiving it output parm it is failing.

2130


What is the batch job?

572


What is the interactive job?

579


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

591


What is the interactive job? What is the batch job? How to change the batch job to interactive job?

628


Suppose I have a pf, it contains 5 members, how to access particular member data from logical file? What is the use of member in pf?

626


How to read a pf in reverse(from last record to first) using cl?

603


What is the use of member in pf?

539


How to index LF by relative record no (RRN)

2832