Click here for aggregate storage version
Execute a stored calculation, the stored default calculation (determined by alter database), or an anonymous (non-stored) calculation string.
Minimum permissions required:
For stored calculations (CALC-NAME): Granted access to the calculation.
For anonymous calculations (CALC-STRING): Database Manager permission.
For default calculation: execute privilege.
Syntax
You can run calculations in the following ways using execute calculation.
Keyword | Description |
---|---|
execute calculation <calc-name> | Run the specified stored calculation script. |
<calc-name> on database | Run the specified stored calculation script against the specified database. |
<calc-string> on <dbs-name> | Run an anonymous calculation, whose body is contained in <calc-string>, against the specified database. |
default on <dbs-name> | Run the default calculation against the specified database. |
Notes
A stored calculation can be associated with an application/database, or with an application only. To execute a calculation stored at the application level, you must specify which database to calculate using the syntax 'on database STRING.'
Example
execute calculation Sample.Basic.calcname;
Calculates the Sample.Basic database using a stored calculation file assocatied with the database.
execute calculation Sample.calcname on database Basic;
Calculates the Sample.Basic database using a stored calculation file assocatied with the application Sample.
execute calculation 'SET MSG ERROR; CALC ALL;' on Sample.basic;
Calculates Sample.Basic using an anonymous (unstored) calculation string.