DB2 graphic  QMF Version 8

Entering an object name on more than one line in the SQL query window

The SQL query currently supports the entry of long names within an SQL statement. When an object name extends beyond a single line, delimited identifiers must be used to enclose the object name. A single SQL query line is limited to 79 bytes. The following example shows how to code an SQL statement that contains an object name across multiple lines:

SQL QUERY MODIFIED LINE 1

SELECT * FROM
"LOCA4567890123456"."OWNER6789001234567891234567890123456789012345678901234567
89012345678901234567890123456789012345678901234567890123456789012345678"."ONAME
6789012345678901234567890123456789012345678901234567890123456789012345678901234
56789012345678901234567890123456789012345678"

You can also write and run SQL queries in a Windows environment by using the DB2 QMF for Windows feature. See Appendix C. The DB2 QMF High Performance Option for more information.

When you enter SQL statements on the SQL Query panel, you need to know:

For more information about writing SQL queries, see the SQL reference manuals that come with your database management system.


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