Modify SQL select statements for the list of values on a particular parameter. Datastream 7i stores this query under a name that the parameter can reference.
Caution: Datastream discourages modifying the installed queries.
Follow these steps to modify report parameter list of values.
Open the Select statement definition form (BMQUER).
Query for the SQL statement to modify.
Click the Record view tab. Datastream 7i displays the Record view page.
SQL statement—Modify the SQL select statement as necessary, including the following restrictions and options:
Select columns—The select statement should select exactly two character columns with name or alias des_code and des_text.
WHERE clause referencing other parameters fields—You can reference another parameter as follows:
Where obj _category like nvl(‘pparm03’, ‘%’)
pparm03 references the parameter with sequence number 3 of the same report. Type pparm03 exactly as it is written.
In this example, the parameter must contain a category. To reference the user language, enter planguage.
Choose File | Save from the menu bar. Datastream 7i saves the information to the database.