Procedure Checks

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


Created October 7, 2009. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com