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.
In order to create a remote procedure, you must have at least one remote server. See Creating remote servers using Sybase Central.
Connect to a database as a user with DBA authority.
Open the Procedures & Functions folder of the database.
From the File menu, choose New > Remote Procedure.
The Create Remote Procedure wizard appears.
Follow the instructions in the wizard.
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.