Previous Page | Next Page

METALIB Procedure

UPDATE_RULE Statement


Overrides one or both of the default add and update actions, and specifies the delete actions.
Requirement: An error is returned if you specify both NOADD and NOUPDATE and omit DELETE. The procedure must have an action to perform if both of the default actions are suppressed.

UPDATE_RULE <=> (<DELETE> <NOADD> <NODELDUP> <NOUPDATE>);

Arguments

DELETE

specifies to delete a table definition in the repository if a corresponding table is not found in the data source. If duplicate table definitions exist, the additional table definitions are deleted unless NODELDUP is specified.

NOADD

specifies not to add a table definition to the repository for tables that have no metadata.

NODELDUP

specifies not to delete duplicate table definitions in the repository. A duplicate table definition has the same SASTableName= value as the table definition being processed. Duplicate table definitions are deleted by default when DELETE is specified. NODELDUP is valid only when DELETE is specified.

NOUPDATE

specifies not to update existing table definitions in the repository to match the corresponding tables in the data source.

Previous Page | Next Page | Top of Page