Visual Basic/Access (VBA) built-in functions are often included in Access Default Values, Validation Rules, and QueryDefs.
Scriptoria implements most Visual Basic built-in functions available in Access by either substituting equivalent DB2 functionality or by User-Defined Functions (UDF).
Use OLE
This is the default when the selected DB2 database is operating on a Windows platform. Scriptoria includes a Visual Basic Active-X object that implements the entire VBA built-in function lexicon using DB2 user-defined functions, providing precisely the same functionality in DB2 that is available in Access.
This is the default when the selected DB2 database is not running on a Windows platform. When VBA built-in functions are encountered, Scriptoria substitutes equivalent functionality using DB2 scalar functions or calls to user-defined functions. This option provides a more platform independent solution but may not all functions available with the OLE option are included .
Note that DB2 user-defined functions are only created when encountered in the Access design.
For a complete explanation see User-Defined Functions and Substitutions.
When UDF’s are deployed, they are saved in the supplied schema. Schema naming rules are the same as those described for Schema (Data Definition Language) above.