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. |