Chapter 5 Working with Information Liquidity Models
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. |