SQL Text

Use the SQL Text window to view the text for an SQL statement, or use the Optimized SQL Text window to view the text for an SQL statement that was rewritten by the optimizer.

Before you begin...

To view text for an SQL statement:

1. Do one of the following:
   • Open the SQL Text window.
   • Open the Optimized SQL Text window.

2. Use the push buttons to Copy Text, Save As, Find, or Print the SQL text that is displayed in the SQL text box.

Note:

• Null characters are stripped out and do not appear in the window.

• Unreadable characters are represented by a period (.).

• For SQL text that is rewritten by the optimizer, character literals are truncated to 100 characters, and graphic literals are not shown.

• The text is an approximation of the text that was actually used by the optimizer.

Related information

• Finding character strings

[ Top of Page | Table of Contents | Glossary | Index ]

[ DB2 List of Books | Search the DB2 Books ]