How to create a map of a native SQL query

1	In Navigator, select the appropriate project.

2	Choose File→New→Map.

3	In Data Source:

Select the appropriate data source.

Select Create a map by entering the native query string, as shown in Figure 2-31.

Choose Next. Map appears.

Figure 2-31

Creating a map by entering a native query string

4	Type a map name, as shown in Figure 2-32.

Figure 2-32

Specifying a map name

Choose Finish.

The map file name appears in Navigator.

5	In the textual query editor:

In the upper pane, type or paste the native SQL query.

In the lower pane, choose Describe Query.

The query’s output columns appear.

To rename a column, type the new name in Output column.

Decide on column names before you build an information object from this map. Changing a column name after you build an information object results in a compiler error in the information object.

If necessary, choose the correct data type from the Data type drop-down list.

The Actuate SQL data type must be compatible with the native SQL data type.

To create a filter on a column, set the column’s Filter property to Predefined and specify the filter’s prompt properties. Figure 2-33 shows Columns and the location of the Prompt editor button for the first column.

To define other column properties, select the column and define the properties in Properties.

Figure 2-33

A native SQL query and corresponding Columns page

Choose Parameters.

The query’s parameters appear.

To rename a parameter, type the new name in Parameter.

Information Object Designer assigns a default name to a parameter based on its position in the query, for example, param_1.

If necessary, choose the correct data type from the Data type drop-down list.

The Actuate SQL data type must be compatible with the native SQL data type.

In Default value, type the parameter’s default value.

Do not create an expression.

To specify the parameter’s prompt properties, choose Prompt editor. Figure 2-34 shows Parameters and the location of the Prompt editor button for the first parameter.

To define other parameter properties, select the parameter and define the properties in Properties.

Figure 2-34

A native SQL query and corresponding Parameters page

Copyright Actuate Corporation 2012