Answer / perfect

We can give max of 8000 fields after rec format of a PF

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)

Answer / manchu.s

8000

Answer / sunil kumar

8000 only

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.

how to see number of logical files depending on a pf?...can we declare more than 20 logical files from a single pf? is it possible

4 Answers   ocbc,

how can i know logical file belongs to which physical file without source?

4 Answers   Cap Gemini,

Suppose if a physical file is having 1000 records, but i deleted 500 records from it. Here the concern is can the size of the file changes or it remains the same... kindly help me out with thorough xplanation.... Thanks in-advance...

6 Answers   ABC, TCS,

How to find the list of source physical files in a library?

0 Answers  

what is open data base command

1 Answers   Active Brains, Cognizant, CSC, CTS,

what is the difference between adding keys & constraints into a phisical file

4 Answers   HSBC,

Define interactive jobs and batch jobs

6 Answers  

what is the difference between adding keys & constraints into a phisical file

6 Answers   HSBC,

How to read a PF in reverse(from last rec to first) using CL?

3 Answers   HCL,

What is open data path?

0 Answers  

How to know the perticular record in pf with out reading?

2 Answers   Cap Gemini,

In how many ways we can create a logical file?`

5 Answers