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.
Thank you for the detailed steps, it worked 100%
Much appreciated.
Regards