Displaying procedures and their properties

To display the schema procedures and their properties:

Procedure

  1. Log on to the MXDM.
  2. In the navigation tree pane, click Database.

    MXDM displays a list of existing systems.

  3. In the navigation tree, expand the contents of the system.

    The list of catalogs appears.

  4. Expand the contents of a catalog.

    The list of schemas appears.

  5. Expand the contents of a schema.

    The Procedures folder appears.

  6. Select a procedure.

    In the right pane, the following tabs related to the procedure appear:

    • Attributes

    • Parameters

    • Related Objects

    • DDL

    • Privileges

    Figure 33 shows the properties of a procedure.

    Procedure properties