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.

Note: You can combine several non-SQL functions in one script.

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.