Using the Text view

The Text view of the Query Editor shows the text of the query in SQL. The Text view is most useful to skilled programmers, for modifying queries. If you have existing queries created outside of QMF Visionary that you want to use in a world, you can copy them into the Text view.

The Text view supports some query clauses that the Query Diagram view does not support. See the DB2 QMF Visionary Developer's Guide for more information.

The SQL Text view supports multiple SELECT statements. When multiple SQL statements are executed, QMF Visionary uses the last SELECT statement for the query result set.

The SQL Text view also supports the use of stored procedures that generate a result set. QMF Visionary assumes a stored procedure if a SELECT statement is not found.

You can include comments in the Text view, but if you subsequently open the query in the Query Diagram view, the comments might be removed. One-line comments must begin with two hyphens (--); multiline comments must begin with a slash and star (/*) and end with a star and slash (*/). Keywords are blue and comments are green. Query parameters are preceded by a colon.

The following figure shows the Text view displaying an SQL query.


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