You specify and control the operation of the Select bean by opening the
property sheet for the Select bean and setting the value of the displayed
properties.

You can control:
- The name of the Select bean. Specify the name as the
beanName property value.
- The database connection characteristics and SQL statement. Specify
these as a composite value for the query property.
- How many rows of the result are retrieved when the SQL statement is
executed. The values of the fillCacheOnExecute,
maximumRows, packetSize, and
maximumPacketsInCache properties control this. These are
properties displayed if the Show Expert Features checkbox is
checked.
- When a lock is acquired for a row. Specify this in the
lockRows property value. This property is displayed if the
Show Expert Features checkbox is checked.
- Whether the result set is updatable. Specify this in the
readOnly property value.
Making a Query Specification
Select
