Procedure Checks (PDM)

The following PDM model checks are made on procedures:

Check

Description and Correction

Procedure name and code uniqueness

Procedure names and codes must be unique in the model.

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 DBMS definition (MaxLen entry, in the Objects > Procedure category).

Manual correction: Modify the procedure code length to meet this requirement

Automatic correction: Truncates the procedure code length to the maximum length specified in the DBMS definition

Procedure definition body empty

A procedure definition should have a body to specify its functionality.

Manual correction: Specify a procedure body from the Definition tab of the procedure property sheet

Automatic correction: None

Existence of permission

Permissions are usage restrictions set on a procedure for a particular user, group or role.

Manual correction: Define permissions on the procedure for users, groups and roles

Automatic correction: None


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