It is possible to create and load applications from the command line by running a batch file. The WhereScape RED Application directory contains an example batch file WSL_Application_Create_Restore_Point_and_Load.bat for creating and loading.
If you right-click this file and select Edit you will see the steps outlined, as well as the details on the options available.
The first step creates a restore point application (R) based on objects about to be loaded. This process calls the command line functionality of RED and creates the application file.
The second step loads an application (A) into a test WhereScape RED repository. It uses an XML Options File to specify various options, calls the command line automation functionality of Setup Administrator, and loads the application (A). Ensure that you have already created and properly defined the XML Options File. Refer to XML Options File for Application Loads for details.
The WhereScape RED Application directory contains example XML files:
WSL_Application_Load_SQL.xmlfor SQL Server
The tags in the XML Options File need to be edited because the login/connection details, etc. need to be set. Refer to XML Options File for Application Loads for details.
The Batch Application Create options and the Batch Application Load options (described below) are listed at the end of the batch file. The values for these variables also need to be customized before running this file.
The process typically involves the following steps:
- Create an application (A) in RED containing your data warehouse changes.
- RUN WSL_Application_Create_Restore_Point_and_Load.bat from the command line; which creates a restore point application (R) and applies application (A) to a test WhereScape RED repository.
- If the changes are incorrect, they can be undone by loading the restore point application (R).
Batch Application CREATE Options
The following options are available on RED to create applications.
Option | Description |
|---|---|
| /BA | Select batch application create. |
| /U | ODBC user name. |
| /P | ODBC password. |
| /C | ODBC DSN name. |
| /A | DSN Architecture |
| /M | meta database for Teradata logon. |
| /N | RED User name. |
| /D | Directory to save application files. |
| /I | New application files identifier. |
| /V | New application files version. |
| /AP | Project name - all objects in a Project; and associated jobs. |
| /AG | Group name - all objects in a Group; and associated jobs. |
| /ALL | All objects - all objects, jobs, and parameters. |
| /RC | Remove connections - drop all connections from the application. |
| /RJ | Remove jobs - drop all jobs from the application. |
| /RP | Remove parameters - drop all parameters from the application. |
| /AF | Absolute application id file name which restores point is being created for. |
If using a trusted connection, the username and password are not necessary.
Batch Application LOAD Options
See RedCli section for details.