Working with SQL statements

You can create, edit, and execute SQL statements using the SQL Builder and the Create A New SQL Statement wizard. You can also generate DADX files.

Use the following topics to start working with the SQL Builder and the Create A New SQL Statement wizard.

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

Editing an SQL statement
Using the SQL editor, you can work with DDL source. The SQL Builder provides a graphical interface for creating SQL statements.

Executing an SQL statement
You can execute and test an SQL statement that you are creating.

Generating DADX files
The DADX wizard supports the creation of a DADX file from a combination of one or more SQL statements, stored procedures, and DAD files. A DADX file is an XML file that is used to create a Web service that accesses a relational database.