Use the Actuate SQL text editor if either of the following conditions is true:
The graphical information object editor does not generate the desired Actuate SQL query, so you must edit the query. For example, if the query includes OR or UNION, you must use the Actuate SQL text editor to edit the query.
You want to type or paste an Actuate SQL query instead of creating it graphically.
If you save a query in the Actuate SQL text editor, you cannot modify the query in the graphical information object editor.
To display the Actuate SQL text editor, complete one of the following tasks:
In the graphical information object editor, choose SQL editor, as shown in Figure 3‑48.
Figure 3‑48 Choosing SQL editor to edit an Actuate SQL query
In SQL Preview, choose Edit SQL.
On New Information Object, select Edit in SQL text editor, as shown in Figure 3‑49.
Figure 3‑49 Choosing to provide the Actuate SQL query in the SQL text editor
You edit the query in the upper pane of the Actuate SQL text editor. The lower pane displays output columns or parameters.
When you edit a query in the SQL text editor, do not use table and column aliases that are identical except for case. For example, do not use both status and STATUS as column aliases.
Displaying output columns
In SQL Text Editor—Columns, to display the query’s output columns and the data type for each column, choose Describe Query, as shown in Figure 3‑50.
To specify column property values, select the column, and specify the property values in Properties.
The graphical information object editor does not generate the desired Actuate SQL query, so you must edit the query. For example, if the query includes OR or UNION, you must use the Actuate SQL text editor to edit the query.
