You use a Select bean to access relational data. Use the SQL page of the Query property editor to specify the SQL statement for the Select bean. You can create a new SQL specification or select an existing SQL specification. When you create an SQL specification, you have the option of composing it manually in an SQL editor or you can use the SQL Assist SmartGuide, to help you compose it.
When you create an SQL specification, you identify a database access class to hold the SQL specification definition. Different Select beans can identify the same SQL specification.
To define a new database access class and add it to the Database Access Class list, select New.
To add an SQL specification to the database access class, select Add.
To edit an SQL specification, select the SQL specifications name in the SQL list and then select Edit.
To remove an SQL specification from the SQL list, select it in the list and then select Remove.
When you finish making the SQL specification, select OK.
To cancel making an SQL specification, select Cancel.
Defining a Database Access Class
Specifying a Connection Alias
Making a New SQL Specification
Composing or Editing an SQL Statement