Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 12.0.1 » SQL Anywhere Server - SQL Usage » Stored procedures, triggers, batches, and user defined functions » Procedures


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.

 Create a new procedure (Sybase Central)

You must have DBA or RESOURCE authority to create procedure.

  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. Click 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.

 Temporary procedures
 Remote procedures
 See also