Business definition / Source strategy
Normally this field will contain a business definition of the column. Such a definition may be a description of the column from a business user's point of view. This field might additionally contain information on where and how the column was acquired. For example if the column is sourced from multiple tables or is a composite or derived column then this definition would normally describe the process used to populate the column. This field is used in the documentation and is available via the view ws_admin_v_fact_col . This field is also stored as a comment against the column in the database.
Host Script Exports
A script based export object will have a Host Script defined. During the export process this host script is executed and the results returned.
During the 'drag and drop' creation of a export object from a single table or view, a script can be generated by selecting one of the 'Script based' export options. This script can then be edited to more fully meet any requirements.
There are a number of conventions that must be followed if these host scripts are to be used by the QAD scheduler.
1 The first line of data in 'standard out' must contain the resultant status of the script. Valid values are '1' to indicate success, '-1' to indicate a Warning condition occurred but the result is considered a success, '-2' to indicate a handled Error occurred and subsequent dependent tasks should be held, -3 to indicate an unhandled Failure and that subsequent dependent tasks should be held.
2 The second line of data in 'standard out' must contain a resultant message of no more than 256 characters.
3 Any subsequent lines in 'standard out' are considered informational and are recorded in the audit trail. The normal practice is to place a minimum of information in the audit trail. All bulk information should be output to 'standard error'
4 Any data output to 'standard error' will be written to the error/detail log. Both the audit log and detail log can be viewed from the QAD Data Warehouse Designer tool under the scheduler window.