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.xml for 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:

  1. Create an application (A) in RED containing your data warehouse changes.
  2. 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.
  3. 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

/BASelect batch application create.
/UODBC user name.
/PODBC password.
/CODBC DSN name.
/ADSN Architecture
/Mmeta database for Teradata logon.
/NRED User name.
/DDirectory to save application files.
/INew application files identifier.
/VNew application files version.
/APProject name - all objects in a Project; and associated jobs.
/AGGroup name - all objects in a Group; and associated jobs.
/ALLAll objects - all objects, jobs, and parameters.
/RCRemove connections - drop all connections from the application.
/RJRemove jobs - drop all jobs from the application.
/RPRemove parameters - drop all parameters from the application.
/AFAbsolute 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.


  • No labels