Create the Input File

The prune utility accepts the list of repository objects you want to delete as a text file.

The utility can accept multiple input files at a time. Object names in the input file must match the fully qualified name that's used in the repository. Wildcards such as "*" and "?" aren't supported in the object name. The syntax rules for the input file are shown in the table.

Object Type	Example	Action
Database	D "Paint"	Deletes the database named "Paint."
Table	T "W_AGREE_D" T "DB"."Catalog"."Schema"."Table"	Deletes the table or alias named "W_AGREE_D" from the Physical layer. Deletes the table or alias named "Table" from the schema named "Schema," contained in the catalog named "Catalog," located in the database named "DB," from the Physical layer.
Column	C "W_AGREE_MD"."AGREE_CD"	Deletes the column named "AGREE_CD" located in a table or alias named "W_AGREE_D" from the Physical layer.
Initialization block	I "External Metadata Strings"	Deletes the initialization block named "External Metadata Strings."
Variable	V CURR_USER	Deletes the variable named "CURR_USER."

For example, a text file that contains instructions to delete a database named Stock Quotes and a physical column named S_NQ_ACCT"."USER_NAME would include the following entry:

D "Stock Quotes" C "S_NQ_ACCT"."USER_NAME"

Use white space as a delimiter in the input file: a single space, tab, or multiple spaces.