DB2 graphic QMF Version 8

Type the SQL statements in the Query window

To type the SQL statements for a query you must first open a new query document. To open a new query document select Create --> SQL Query. The query window opens. You can type the SQL statements directly in the active query window.

Expression Builder

You can use the Expression Builder to help you build conditional expressions that can be included in the SQL statements for your query. Click the Expression Builder to access a submenu, or palette, of SQL elements for building an SQL expression. The Expression Builder palette contains common elements such as:

A template for each expression element you select is inserted into the query document. This provides the fundamental structure for you to substitute parameters for the query in place of the <expression>. For example,

CASE <expression> WHEN <expression> THEN <result-expression> ELSE
<result-expression> END

Note:
This command is disabled for queries in the prompted or diagram formats.


Go to the previous page Go to the next page

Downloads | Library | Support | Support Policy | Terms of use | Feedback
Copyright IBM Corporation 1982,2004 Copyright IBM Corporation 1982, 2004
timestamp Last updated: March, 2004