WebSphere V5.0 : Creating SQL statements

You can create an SQL statement using either the SQL query builder or the SQL query wizard. Both tools support the creation of SELECT, UPDATE, INSERT and DELETE statements. The SQL query builder also supports WITH (DB2 only) and FULLSELECT statements. Any statement you create is stored in a file with the extension .sqx.

To create an SQL statement using the SQL query builder:

Switch to the Data perspective.
.
Switch to the Data Definition view by selecting the Data Definition tab.
.
Expand the project or folder that contains your database, then expand the database until you see the Statements folder.
.
Right-click the Statements folder.
.
Click New > and the type of statement you wish to create.

Name

Enter a name for your statement and click OK.

Your statement will be added to the Statements folder and will open in the SQL query builder. Complete the statement using the SQL query builder:

Name

SQL query builder

The SQL query wizard and SQL query builder both provide a visual interface for creating and executing SQL statements. You can create a simple query using the SQL query wizard, or you can use the SQL query builder that supports a wider range of statements. Statements generated by these tools are saved in a file with the extension .sqx.

The SQL query builder contains a number of panes and tabs. The options available depend on the type of statement you create. The following screen capture shows the basic layout of the SQL query builder: