DB2 graphic QMF Version 8

Expression Builder

Select Query--> 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:

Note:
Connect to the server before you use the Expression Builder.

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