Chapter 5 Building Triggers and Procedures

Creating a stored procedure from the physical diagram

You can create a stored procedure or function from the physical diagram.

To create stored procedure from the diagram:

1. Click the Procedure tool.
2. Click an empty space in the diagram. The following symbol appears at the click position:
   
3. Right-click the mouse button to release the Procedure tool.
4. Double-click the new procedure or function symbol in the diagram to display the procedure or function property sheet.
5. Type a name and a code for the procedure or function.
   
6. Click Apply.
   
   The creation of the new procedure or function is committed.
7. Click the Definition tab.
   
   The Definition page appears.
8. Select Procedure from the dropdown list box at the top of the page.
   
   or
   
   Select Function from the dropdown list box at the top of the page.
   
   The template definition appears in the text box.
9. Type the procedure or function definition code in the text box.
   
   
      Inserting script items
   You can insert script items into the definition as follows:
   Click in the definition where you want to insert a script item. Click a script item tool.
   Select a script item from the menu.
   The script item appears at the click point.
   
   
10. <Optional> Click the Script tab.
    
    The Script page appears. You can define begin and end script for the procedure or function.
11. Click OK.

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