SQL Statement Parameters

For additional functionality, you can specify one or more input parameters for a SQL query operation. This allows you to specify values in the query at runtime. You must provide the following information for each parameter:

The relationship between Name and DBName is demonstrated given the following statement: select * from myTable where UNIT_ID>:UnitID UnitID is defined to be a parameter. When the SQL Statement Parameters property dialog appears, DBName is set to UnitID because that is the defined name of the parameter. Name is set to UnitID because the default value is also the defined name of the parameter. You can change the value of Name, but that provides no benefit.

The SQL statement you specify for an operation can contain parameters.  Stored procedure in parameters become inputs in the schema, stored procedures out parameters become outputs in the schema, and stored procedure in/out parameters become inputs and outputs in the schema. for the operation at runtime.  Parameters are specified in the SQL with as :parameter.  For example, the following query selects customers from a customers table:

select * from customer where state = :state

The :state is a parameter that will be specified at runtime.  Different states can be specified at runtime to cause the operation to retrieve customers in different states.