Interested to Buy Any Domain ? << Click Here >> for more details...
Maximum how many fields we can create under a record format
of PF?
- 5 Answers
- 10519 Views
- I also Faced
- E-Mail Answers
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 |
Why journalling is compulsory before commitment control?
Can we concatenate fields in physical file? If yes how can we do?
What is the interactive job? What is the batch job?
one physical file can have how many max of logical files? what is the primary file?
1. How can I create a LF using crtlf command based on a particular member in a multimember PF? Where I have to specify the member name? 2. How to differentiate between the types of join from a Join logical file DDS. Is it possible to have different types of Join Logical files? 3.Any performance difference between Opnqrf and Embedded SQL? When I should prefer Opnqryf and when SQL? 4. I know access path is the path chosen by the program to retrieve data. It can be of keyed access path or arrival sequence. *IMMED- *IMMED description says access path is updated each time record is added or deleted from a member. - What is updating here? *REBLD - The access path is completely rebuilt each time a file member is opened. The access path is maintained until the member is closed, then the access path is deleted. - I am not able to understand this completely. Could anyone explain these more clearly? 5.What is the purpose of using activation group. I know it is a resource allocator, but other than this any other benefits of using an activation group?
hi iam very new to as400. i had created one physical file can any one tell command to enter data in to that
How to add a field to a PF and compile it without loss of data?
what is the purpus of the chain and setll and setgt ?
Can anybody tell why Journalling is compulsary before Commitment Control?
what is general and type of general
What is open data path? And what is the difference between access path and open data path?
how to update physical file using logucal file with example
RPG400 
