...
Procedures and macros gives the user a possibility to reuse a certain snippet of the code. They can be distinguished between parameterizable procedures and simply reusable macros. Another advantage: Procedures (#PROCEDURE) are stored in the data dictionary so that their availablity is (according to the user's rights) system wide.
...
There cannot be installed more than one procedure with the same name, so you may delete a procedure by calling #DROPPROCEDURE before.
Example
The example creates a procedure with name "setSomething" and has two parameters (varX and attribute). Remeber, order is important! The procedure calls a #RUNQUERY-Command including both parameters. See #EXECUTE command how this example is used.
...
The #EXECUTE command can be used for running installed procedures, which were created by using the #PROCEDURE command.
Usage
Procedures can be compared to stored procedures in a database system or like methods in a programming language. It allows defining a snippet of Odysseus Script that is reusable. Installed procedures can be executed at follows:
...
You can create the procedure by using the #PROCEDURE command or delete a procedure by calling #DROPPROCEDURE
Example
This example concludes the one from from #PROCEDURE. Therefore we have two parameters (varX and attribute). The following executes the "setSomething" procedure and sets varX=1 and attribute=b.
...
The command can be used to remove stored procedures, which were created by using the the #PROCEDURE (see for more information about procedures) command.
...
You can create the procedure by using the #PROCEDURE command or execute a procedure by calling #EXECUTE
Example
This example concludes the one from from #PROCEDURE. Therefore, we want to remove the "setSomething" procedure:
...