DatabaseSelect
Specifies the conditions on a database select.
This function is used as the I/O expression of the element that contains the data to be read.
Database select is used to define the selection criteria on the rows that are to be processed. You can provide only the "where" portion of the selection criteria, or provider the full contents of the SQL Select statement.
In order to parametrize the select statement, you can access the Map Execution Properties from within the Where String or Query String properties. Do this by specifying the name of the property as ${propertyName}. For example DepartmentCode = ${departmentCode}.
This function can only be used in the IO/Database tab.
Properties
| Where Condition | Enter a SQL condition as specified in a Where clause without the use of the word "Where". Specify only this or the Query String but not both. See notes below about how to parametrize the query. |
| Query String | Enter the entire HQL (HQL is similar to SQL) query string to be used for the select. This allows all of the parts of the select statement. Specify only this or the Where String but not both. See notes below about how to parametrize the query. |