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 |
I had created one physical file tell me command to enter data in to?
There are six records in a file and we are going to update that records and used commit operation when it complete the update but suppose when it updating the third record,a error occured and operation failed.Is previously two records will be update or whole operation will be rollback? Please confirm it.
How we can't update join logical files?
how to eliminate the level check error
how to update physical files using normal logical file
how to restrict upon adding the data for field reference file in DB400
Is it possible to create a logical file whose Physical file is not in same library?
what is multiple member pf
what is open data path? and what is the diff b/w access path and open data path?
Maximum how many fields we can create under a record format of PF?
What is the interactive job? What is the batch job? How to change the batch job to interactive job?
Define interactive jobs and batch jobs