updatchorph - Delete Orphaned Attachments

updatchorph [-n] [-d] [-m maxtrans] productline [filename]

Delete all attachment records, in an entire product line or in an individual file, that do not have a corresponding parent record.

Program Option	Description
d	Delete attachment records that do not have a corresponding parent record. If you do not use this option, updatchorph produces a report listing the number of orphaned attachments; it does not delete any attachment.
m	Specify, in maxtrans , the number of records to delete at one time (internal to the program; that is, within one database transaction). The default of 50 helps to limit the loss of data in a recovery situation.
n	Remove null space in attachment tables.
productline	Product line you want to delete orphaned attachments for.
filename	File name you want to delete orphaned attachments for.