Deleted Fields on FDT

Good day,

How do I remove the logically deleted fields from the FDT. The fields appear as deleted but are still part of the FDT.

Thanks in advance.

Kugh,

you will need to DECOMPRESS the file, specifying a FORMAT that excludes the deleted fields, then re-COMPRESS and load the file.

1 Like

While I totally agree with Wolfgang, I have occasionally used a different approach:

Use PREDICT to copy the file definition to a new file with similar name.

Remove the logically deleted fields from the new file.

Generate a DDM and Generate the Adabas File (or generate ADACMP).

Then write a simple NATURAL program essentially like this:

READ DDM-OLD

Move by name DDM-OLD to DDM-NEW

ET every 50 records.

end-read

ET final

Then after that renumber the files and rename and regen DDM’s

The advantage of this approach is that you don’t have to take the file out of service.

Yes you do want to prevent updates, but it can remain read only….

Just an alternative idea.