WhereScape RED generates template scripts to assist in the loading of textual files from UNIX or Windows. These scripts are generated when a UNIX or Windows file is dragged into a Load table target and one of the 'Script based' file load options is chosen. Typically, script loads are used when some complexity prevents the use of the standard file-based load. In such a case, the script will need modification.
Note
UNIX scripts are only supported for an Oracle data warehouse running on a UNIX platform.
The following sample scripts are covered in the remainder of this section:
- Windows script for SQL
- UNIX script for Oracle
- Windows script for Oracle
Note
- Windows script supports both DOS Batch and PowerShell scripts.
- While Windows and UNIX scripts are available on Load table objects, currently only Windows Scripts are available on other object types that are created in a Custom Database Connection.
- Additional host script language types which can be applied to Script objects can be defined in RED. Refer to Host Script Languages for details.