Specifying a connection and SQL statement

The query property of a Select bean, the action property of a Modify bean and the procedure property of a ProcedureCall bean are three examples of what we generically refer to as data properties. The two parts of a data property are:

Connection alias
Specifies database connection characteristics for the bean
SQL specification
Specifies an SQL statement for the bean

To edit a data property:

  1. Open the property sheet for a Select, Modify or ProcedureCall bean by double-clicking on the bean.
  2. Select the query, action or procedure property value and click on the box in the value field. The data property editor displays. 


    Query property editor

  3. Create a connection alias or select an existing connection alias.
  4. Create an SQL specification or select an existing SQL specification.


Related procedures
Specifying a connection alias
Making an SQL specification