Host scripts are generated when a script based file load is chosen during a file drag and drop from a Windows or UNIX connection. Scripts can also be created manually provided the rules for their inclusion into the scheduling process are followed. This chapter covers the generation, editing and testing of host scripts as well as explaining the components required to allow them to work in the scheduler environment.

QAD Data Warehouse Designer generates template procedures to assist in the various phases of the data warehouse build process. A procedure is generated by selecting the (Build Procedure...) option from a drop down box that is used to display the update, initial build, or post load procedure in a table's properties.

For Load tables a post load procedure can be generated by selecting the option above. This post load procedure is designed to assist in the management of file loads where a trigger file has been used.

For Dimension, Stage, Fact and Aggregate tables an Update or Initial Build procedure can be generated by selecting the option above from the appropriate drop down box. When an 'Update' procedure generation is selected for a Dimension a get_key function is also automatically created.

If a new procedure is created from scratch (i.e. not auto generated) then an outline of the syntax required by the QAD scheduler can be generated by selecting the Tools/create procedure outline menu option when in the procedure editor.