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 EPM business applications.

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

Non-SQL scripts can be run with the Infor API Gateway function ExecuteLoadQuery or Application Engine.

See "Scripts" in the Relational modeling section.