The following ILM model checks are made on procedures:
Check |
Description and Correction |
---|---|
Procedure name and code uniqueness |
Procedure names and codes must be unique in the namespace. The list of parameters must be taken into account. Manual correction: Modify the duplicate name/code Automatic correction: Appends a number to the duplicate name/code |
Procedure code maximum length |
The procedure code length is limited by the maximum length specified in the XEM definition [CodeMaxLen entry, in the Objects > Settings category] and in the naming conventions of the model options. Manual correction: Modify the code length to meet this requirement Automatic correction: Truncates the code length to the maximum length specified in the XEM definition |
Undefined source |
A procedure corresponds to a stored procedure linked to a table to replicate. A procedure should have a source stored procedure defined. Manual correction: Select procedures from source database from the Procedures tab of the Publication property sheet Automatic correction: None |