Add Input Parameters

You can define input parameters for the SELECT, WHERE, or FROM clause of a parameterized query.

•

For the SELECT clause, add it from a Column cell in the Grid panel. See Adding a Parameter to a SELECT Clause.

•

For the WHERE clause, add it from a Criteria cell in the Grid panel. See Adding a Parameter to a WHERE Clause.

•

For the FROM clause, include a procedure with an input parameter in a parameterized query. See Adding a Parameter to a FROM Clause.

This section provides the details of adding parameters using an editor window (Add Parameter). You can also type the parameters in the Grid panel.

About Parameter Names

•

When you type a parameter, it must be in the format {param <name> <type>}. The parameter name is case-sensitive.

•

Several parameters can have the same name, provided they are distinguished by lowercase and uppercase letters, or by data type.

•

Different parameters can have the same name and data type, if they have different aliases.