Chapter 5 Working with Information Liquidity Models


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

 


Copyright (C) 2007. Sybase Inc. All rights reserved.