Model Database Functions
Database Functions are a feature that some DBMS products implement to provide users with a mechanism - as a routine - to extend the functionality of the database server. In the Database Builder, you create and define database Functions as individual objects.
Access Tools | Database Builder | Right-click on Functions Package | Add new Function
A database Function element is immediately added to the Package, with the name highlighted for change. Type an appropriate name.
To define the database Function, double-click on it. The Function: <function name> dialog displays.
|·||The Database field defaults to the DBMS for which you are defining the database|
|·||In the Notes field, type some notes on, or a description of, the Function|
|·||In the Function definition field, type the full Function definition; the code editor provides Intelli-sense for basic SQL keywords and functions|
To delete a database Function, right-click on the Function name and click on the Delete <function name> option. A prompt displays to confirm deletion of the Function and its contents; click on the Yes button.
|·||If you create a database Function element external to the Database Builder, in any part of the model other than the Functions Package, that Function element is automatically reassigned to the Functions Package|
|·||Database Functions created as individual objects are represented in the model hierarchy in the Database Builder as Class element icons; if you have Functions as operations of a container Class (created external to the Database Builder) they are represented in the model hierarchy as Class element icons with a pink 'operation' icon in the bottom right corner|