You can automatically create an Application from:
- Projects or Project Groups—refer to Building an Application from Projects or Groups for details.
- Object Groups—refer to Building an Application from Object Groups for details.
- Diagrams—refer to Creating an Application from a Diagram for details.
An application is created by selecting the Tools > Build Deployment Application menu option. 
The following screen is displayed:
Once the application is defined and the objects selected, the application files are generated when you click the OK button.
If procedures are compiled as part of the subsequent application load, the compiles occur in the order in which they are listed in the application. If procedure dependencies exist, ensure that their ordering in the application object list is correct. There are three tabs in the Build Deployment Application screen.
- The first tab defines the application.
- The second tab lists the objects to add or replace in the destination repository.
- The third tab lists the objects to delete in the destination repository.
Define an Application distribution
Application
| Fields | Description | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Output Directory | The directory to which the application files will be written. By default, this is the WhereScape program directory. To browse for the required folder, click the Browse... button.
| ||||||||||||
| Application Identifier | The application identifier is a four-character code used to uniquely identify the application. This identifier is used in the naming of the files that are created to contain the application data. | ||||||||||||
| Application Version | The version is a character string that provides a version number for reference purposes. This version number is displayed when applications are being loaded and is used in the naming of the files that are created to contain the application data. As such, it must contain characters that are valid in a Windows file name | ||||||||||||
| Application Name | The name by which the application is known. This name is displayed during the selection of an application to load and is recorded in the metadata of the repository into which an application is loaded. It is not used, apart from documentation purposes. | ||||||||||||
| Description | This description is displayed during the selection of an application to load. It is not used at any other point, apart from documentation purposes. | ||||||||||||
| Application Files | When an application is created the following files are built, where XXXX is the application identifier and NNNNN is the application version.
| ||||||||||||
| Previous Application | Click the Browse button next to Previous Application to choose a previously built application to use as a list of objects to include in the new application. After using a previous application as a starting point for this application, additional objects can be added or removed from the application. | ||||||||||||
| Pre-application load SQL | This text box enables you to enter an SQL statement that is executed before the application is loaded. For example, you may wish to drop the date dimension before loading the application because we have changed the primary key constraint. In such a case, you would enter 'drop table dim_date' in this field to have the table dropped before the application is loaded. | ||||||||||||
| Post application load SQL | This text box enables you to enter an SQL statement that is executed after the application is loaded. For example, you could execute a function to populate a table. |
Objects to Add/Replace
This tab enables you to select the objects to add or replace in the destination repository. Double-click a Project/Group folder to display the objects that are associated with them. Objects can be moved from the left object tree pane to the right pane by double-clicking an object or by using the > button.
Maximum number of objects in an application
5000 objects (including jobs)
2000 source views of views
1000 jobs
- Projects or Groups that have been flagged as inactive are not displayed in the Available pane. Refer to Maintaining Group/Project Active Flag for details.
- You can select multiple objects using the Windows standard keyboard keys (CTRL or SHIFT) for multi-selection.
Objects to Delete
This tab enables you to select the objects to delete in the destination repository. Click the Available drop-down field to select an option for displaying objects in the left object tree pane, each option is described in the table below. Double-click a Project/Group folder to display the objects that are associated with them. Objects can be moved from the left object tree pane to the right pane by double-clicking an object or by using the > button.
Options | Description |
|---|---|
Archived Objects | This option includes all objects that have been versioned and deleted. This is the case in a development repository, where the object was removed after versioning. This is the default option. |
Current Objects | This option includes all the currently available objects and their associated Projects or Groups. |
All Objects | This option includes all the Current Objects plus the Archived Objects (deleted / versioned). Objects that were versioned and deleted will appear in All Objects but will not appear under any Projects or Groups. |