Overview of SQL statements

You can create and organize SQL statements against your database for use in testing and analysis of your design and also for use in an application.

The SQL statements that you create are organized in a Statements folder under the database to which they apply.

Limitations of SQL query creation
This topic describes limitations of SQL query creation.

 

Parent topic

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.">Creating an SQL statement