It is possible to create and load applications from the command line by running a bat file. The WhereScape RED Application directory contains an example bat file WSL_Application_Create_Restore_Point_and_Load.bat for creating and loading.
Right-click this file and select Edit to see the steps outlined, as well as the details about 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 file to specify various options, calls the command line automation functionality of Setup Administrator and loads the application (A).
The WhereScape RED Application directory contains example XML files:
- WSL_Application_Load_SQL.xml for SQL Server
The tags in the XML file must be edited as the login/connection details, etc. must be correctly defined.
The Batch Application Create options and the Batch Application Load options are listed at the end of the batch file. The values for these variables must also be customized before running the 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 in 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 |
| /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 user and password are not necessary.
Batch Application LOAD Options
The following options are available in Setup Administrator to load applications.
| Option | Description |
|---|---|
| /AL | Select application load. |
| /AF | Absolute application ID file name. |
| /LF | Absolute log file name. |
| /PF | Absolute XML parameter file name. |
| /SO | Stay open - Setup Administrator does not close after the application has been created. Relevant for /AL LOAD option. Relevant for -QA, -QR, -WS, -QL, and -QV application switch options. Not relevant for -QS switch option. For switch options, refer to SQL Server Quick Application for details. |