To view or edit a procedure's properties, double-click its Browser or list entry. The property sheet tabs and fields listed here are those available by default, before any customization of the interface by you or an administrator.
|
Property |
Description |
|---|---|
|
Publication |
[read-only] Specifies the publication in which the procedure is defined (see Publications (DMM)). |
Name/Code/Comment |
Identify the object. The name should clearly convey the object's purpose to non-technical users, while the code, which is used for generating code or scripts, may be abbreviated, and should not normally include spaces. You can optionally add a comment to provide more detailed information about the object. By default the code is generated from the name by applying the naming conventions specified in the model options. To decouple name-code synchronization, click to release the = button to the right of the Code field. |
Stereotype |
Extends the semantics of the object. You can enter a stereotype directly in this field, or add stereotypes to the list by specifying them in an extension file. |
|
Source procedure |
Specifies the source procedure to be replicated. Click the Properties tool to the right of the field to display the source object property sheet. |
|
Remote procedure |
Specifies the remote procedure to which the procedure will be replicated. By default its name is identical to the source procedure name, but you can select another procedure in the list. |
Keywords |
Provide a way of loosely grouping objects through tagging. To enter multiple keywords, separate them with commas. |
This tab lists the call parameters of the procedure. Stored procedures can use parameters to accept values from and return values to the calling replication process.
For example, the rs_delexception procedure used to delete a transaction in the exceptions log takes the transaction_id parameter, which specifies the number of the transaction to delete.
Each parameter contains the following properties:
|
Property |
Description |
|---|---|
|
Procedure |
[read-only] Specifies the procedure to which the parameter belongs. |
Name/Code/Comment |
Identify the object. The name should clearly convey the object's purpose to non-technical users, while the code, which is used for generating code or scripts, may be abbreviated, and should not normally include spaces. You can optionally add a comment to provide more detailed information about the object. By default the code is generated from the name by applying the naming conventions specified in the model options. To decouple name-code synchronization, click to release the = button to the right of the Code field. |
Stereotype |
Extends the semantics of the object. You can enter a stereotype directly in this field, or add stereotypes to the list by specifying them in an extension file. |
|
Data type |
Specifies the data type of the parameter. |
|
Length |
Specifies the maximum length of the data type. |
|
Precision |
Specifies the maximum number of places after the decimal point. |
Keywords |
Provide a way of loosely grouping objects through tagging. To enter multiple keywords, separate them with commas. |