Combined lenght of fields per adabas file

, ,
1

Hi,

I would like to know what is the size of the combined length of all the fields in a adabas file?

2

Do you want the length of a specific record as stored in the database, that is, its compressed record length (CRL)? Or do you want the length of the record returned from the database, that is, the decompressed record length (DRL)? The DRL is the same for every record in the file while the CRL is computed from an individual record’s contents.

You will find the average CRL in an ADAREP report. A specific CRL will be seen in a Natural DBLOG report (mainframe only).

There are several ways to see the DRL My favorite is to write a Natural program.

DEFINE DATA LOCAL
1 MYFILE VIEW MYFILE-DDM
  2 FIRST-FIELD
  ...
  2 LAST-FIELD
1 REDEFINE MYFILE
  2 #X (A1000000)
END-DEFINE
END

The view, MYFILE, (and so the DDM) must contain every field defined in the Adabas file. The length of #X is intentional; it will cause a syntax error. But the error message (NAT0039) will include the actual record length which is the DRL!