An SQL specification contains an SQL statement plus meta-data about the statement. You can compose a new SQL specification or edit one that you already composed.
You compose a new SQL statement by selecting Add in the SQL page of the data 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 a data 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 query visually
Composing an SQL INSERT, UPDATE, or DELETE visually
Composing an SQL procedure call visually
Composing an SQL statement manually
Making a new SQL specification