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.
Use the SQL Anywhere 12 plug-in to connect to the database as a user with DBA or Resource authority.
In the left pane, double-click Procedures & Functions.
Choose File » New » Procedure.
Follow the instructions in the Create Procedure Wizard.
In the right pane, click the SQL tab to complete the procedure code.
The new procedure appears in Procedures & Functions.
Discuss this page in DocCommentXchange.
|Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0|