Creating procedures

In Sybase Central, the Create Procedure Wizard provides the option of using procedure templates. Alternatively, you can use Interactive SQL to execute a CREATE PROCEDURE statement to create a procedure. You must have DBA or RESOURCE authority to create procedure.

 To create a new procedure (Sybase Central)
  1. Use the SQL Anywhere 12 plug-in to connect to the database as a user with DBA or Resource authority.

  2. In the left pane, double-click Procedures & Functions.

  3. Choose File » New » Procedure.

  4. Follow the instructions in the Create Procedure Wizard.

  5. In the right pane, click the SQL tab to complete the procedure code.

    The new procedure appears in Procedures & Functions.

 Example
 Temporary procedures
 Remote procedures
 See also