Enterprise Data Manager Guide

6.5.1
- 6.5 HotFix 1
- 6.5
- 6.4.4
- 6.4.3 HotFix 1
- 6.4.3

Back Next

Creating a List of Values

Create a List of Values to associate values with a parameter for an entity.

During Archive Definition, you supply values for these parameters from a List of Values. The list is populated internally by building an SQL query according to a List of Values definition.

To create a List of Values, perform the following steps:

Select the required Application Module and click

Insert

List of Values

The first page of the

List of Values Creation Wizard

appears as shown in the following image:

Enter a name and description for the List of Values and click

The following page appears:

In the second page of the List of Values Creation Wizard, select a schema.

To add a schema to the

Selected

pane, select a schema from the

Select Schema(s)

pane and click the down arrow. To clear the selection, select the selected schema and click the up arrow (Step 2). When you are finished, click

The following page appears:

In the third page of the List of Values Creation Wizard, select Business tables. To search for a table, enter the table name in the Find field at the top of the page.

To select Business Tables (Step 3) click the down arrow (or click the up arrow to clear the selection). Click

The following page appears:

In the last page of the List of Values Creation Wizard, define aliases for each table you selected.

Specify aliases for each of the selected tables (Step 4) and click

Finish

When you complete the wizard, the List of Values is created and appears in the

List of Values

tab of the Explorer pane. Each List of Values appears with the following tabs in the Details pane:

List of Values Detail Tab	Function
General Information	Basic information about the List of Values such as: Auto generated ID Name (specified in List of Values Creation Wizard ) Description (specified in List of Values Creation Wizard ) Comments
Tables	Selected tables with the following information: Order of Tables according to selection from List of Values Creation Wizard . To change the order, click the up or down arrows. Table Name Table Alias (as specified in List of Values Creation Wizard ). Check boxes to determine whether to include the table in the FROM clause of the SQL query. To add or delete tables, click Add or Delete .
Where Clause	The WHERE clause for filtering data.
Display Columns	Columns to select in the SQL query. Each column appears with the following information: Order of selection. To change the order, click the up arrow and down arrow. Expression to execute on the column. For example, TOCHAR(). Generally, you specify the column name here. Data Type for the column. Label / Alias for the column (column heading) To add or delete columns, click Add or Delete .
Return Columns	Return value for the SQL query (not displayed in the List of Values).
Order	Columns for the ORDER BY clause for sorting data.
Test	The SQL query, built from the previously specified information. If values are not valid and the query does not comply with SQL syntax, error messages appear in this area.