An SQL statement comprises the SQL specification for a Select bean. You can compose a new SQL statement or edit one that you already composed.
You compose a new SQL statement by selecting Add in the SQL page of the Query property editor. This opens the New SQL Specification window. You have two ways to compose the new SQL statement:
You are prompted to specify one of these SQL composition approaches in the New SQL Specification window.
You make a request to edit an SQL statement by selecting Edit in the SQL page of the Query property editor. This opens either the SQL Assist SmartGuide or the SQL editor, depending on which one you used to initially compose the SQL statement.
Composing an SQL Statement Visually
Composing an SQL Statement Manually