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

SQL Anywhere 10.0.1 » SQL Anywhere Server - SQL Usage » Using Procedures, Triggers, and Batches » Introduction to procedures

Returning procedure results in result sets Next Page

Advanced information on procedures

Creating a temporary procedure

To create a temporary procedure, you must use the CREATE TEMPORARY PROCEDURE statement, an extension of the CREATE PROCEDURE statement. Temporary procedures are not permanently stored in the database. Instead, they are dropped at the end of a connection, or when specifically dropped, whichever occurs first.

For more information on creating temporary procedures, see CREATE PROCEDURE statement.

Creating a remote procedure

In order to create a remote procedure, you must have at least one remote server. See Creating remote servers using Sybase Central.

To create a new remote procedure (Sybase Central)
  1. Connect to a database as a user with DBA authority.

  2. Open the Procedures & Functions folder of the database.

  3. From the File menu, choose New > Remote Procedure.

    The Create Remote Procedure wizard appears.

  4. Follow the instructions in the wizard.

  5. When the wizard finishes, you can complete the code on the SQL tab in the right pane.

    The new remote procedure appears in the Procedures and Functions folder.