Maximum how many fields we can create under a record format
of PF?
Answers were Sorted based on User's Feedback
Answer / perfect
We can give max of 8000 fields after rec format of a PF
| Is This Answer Correct ? | 26 Yes | 0 No |
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 |
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 |
What is the purpose of the chain and setll and setgt?
how to update physical file using logucal file with example
How to insert more than one record to a pf at a time?(Bulk insert to a pf)
How many libraries can be there in a library list?
how can we write LF using flatfile.
what is error handling concepts in cl
How many max. Record format a logical file have?
How to retrieve a physical file after deleting that ? what is keyword used for that....??
There is one string as A B C and wanted to display string as Shri A Shri B Shri C, how we can do this in sql? If we have around 100 values in string like this, each value should be displayed with initials as Shri.
How to know logical file belongs to which physical file without source?
Last statement of any rpg program is lr?
I want to change the attribute of field or want to add new field in existing PF but condition is format level identifier should not change, is it possible?