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

SQL Anywhere 12.0.0 (Français) » SQL Anywhere Server - SQL Usage » Stored procedures and triggers » Using procedures, triggers, and batches » Introduction to 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. 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.

 Temporary procedures
 Remote procedures
 See also