Chapter 4 Building an Information Liquidity Model

Creating a procedure

You can create a procedure in any of the following ways:

• Select the Procedures tab in a publication property sheet.
• Right-click a publication in the Browser, and select New→Procedure.

For more information about the different ways to create objects, see the "Getting Started with PowerDesigner" chapter in the General Features Guide .

When you create a procedure in the Procedures tab of the publication property sheet, you can:

• Create a procedure in the list, which implies typing a name and a code for the procedure.
• Select from a selection list one or more tables or views to add in the Procedures tab

The selection list can come from:

• The source database, if a PDM is already associated with it to describe its schema. You use the Add Procedure from Source Database tool in the toolbar
• The remote databases, if you do not know the schema of the source database or consolidated database, but know the one of the remote database, as a PDM is associated with it. You use the Add Procedure from Remote Databases tool in the toolbar

To create a procedure from the publication property sheet:

1. Open a publication property sheet.
2. Click the Procedures tab.
3. Click a blank line in the list.
   
   or
   
   Click the Add a Row tool.
   
   An arrow is displayed at the beginning of the line.
   
   Type a name and a code for the procedure.
   
   or
   
   Click the Add Procedure from Source Database tool, if a PDM is already associated with the source database.
   
   or
   
   Click the Add Procedure from Remote Databases tool, if you do not know the schema of the source or consolidated database but a PDM is associated with at least one remote database.
   
   A selection dialog box is displayed
   
   Select one or more tables or views and click OK.
4. Click OK to close the dialog box.

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