Home

 

Using the SQL Builder

The SQL Builder has three main sections:

SQL source pane-The SQL Source pane contains the source code of the SQL statement. You can type the SQL statement in this pane, or use the features that are provided by the SQL builder to build the statement. Content assist is available as you type and through the pop-up menu in the SQL Source pane. This pane also provides content tips through the pop-up menu. A content tip shows a simple example for the type of statement that you are creating.

Tables pane-The Tables pane provides a graphical representation of the table references that are used in the statement. In this pane, you can add or remove a table, give a table an alias, and select or exclude columns from the table. When you build a SELECT statement, you can also define joins between tables in this pane.

Design pane-The options in the Design pane vary, depending on the type of statement that you are creating. When more than one set of options is available, the options appear as notebook pages. For example, for a SELECT statement, some of the options include selecting columns, creating conditions, creating groups, and creating group conditions.

ibm.com/redbooks