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 |
How to insert more than one record to a pf at a time?(Bulk insert to a pf)
In how many ways we can create a logical file?`
Hi, Please give the answer to this question? I have Phisical file with 100 records,there is no any duplicate records in this pf.Based on this pf one Logical file i have used.But this lf is viewing only 80 records only of that pf?What is the reason for this?Please give me answer?
Suppose I have a pf,it contains 5 members,how to access particular member data from logical file ?and what is the use of member in pf?
I had created one physical file tell me command to enter data in to?
How to find the list of source physical files in a library?? Is there any way to get a list??
How to retrieve a physical file after deleting that ? what is keyword used for that....??
how to update physical files using normal logical file
If we use the file level keywords like LIFO, FIFO, FCFO in a file, can we see the impact of it by doing the run query of the file? if not how can we see the impact of these keywords.
how to update physical file using logucal file with example
WHAT IS THE DIFFERENCE BETWEEN 'COLHDG' AND 'ALIAS'?
Is Constent can be define as a key field?