Non-SQL scripts
Relational modeling supports non-SQL scripts to automate a series of data manipulations.
You can use these non-SQL functions in scripts to manipulate data in Staging tables:
- ExecuteScript
Runs SQL scripts.
- ExecuteLoadQuery
Runs load queries.
- ExecuteHierarchyMapping
Runs hierarchy mappings to fill the custom OLAP hierarchies that have been created for custom sub plans. This function is not used for business objects.
- ExecuteFactMapping
Runs cube mappings to fill the custom OLAP cubes that have been created for custom sub plans. This function is not used for standard cubes of the Infor d/EPM business applications.
Non-SQL scripts can be run with the Infor ION API function ExecuteLoadQuery or Application Engine.
See "Scripts" in the Relational modeling section of this documentation.