| Generate Alias | SQL Query | |
This chapter describes the SQL Error Messages tool which displays the text associated with an SQL error code in a similar way to the DSNTIAR utility.
You can use this tool to look up text associated with any SQLCODE. In addition, this tool is invoked if you encounter an SQL error using any of the HCO tools. For example, if you haven't started DB2 and get a SQLCODE of -1032, you see the SQL Error Message tool.
The SQL Error Message tool (see Figure 14-1) appears when you select Tools > HCO > SQL Error Message from the IDE.
Figure 14-1: SQL Error Message Tool Window
The following elements make up the SQL Error Message window:
The following list shows the buttons in the toolbar and the functions that they invoke:
 |
Retrieve the error message text that goes with SQLCODE. |
 |
Display the online HCO User's Guide, a hypertext file that describes how the SQL Error Message tool works. |
The menu bar is another way of invoking SQL Error Message functions. The menu bar is composed of two menus: SQLCODE and Help.
To display error messages or to exit the tool, use the SQLCODE menu. You can also display this menu by right-clicking on the SQL Error Message window (see Figure 14-1)
| Display message | Retrieve the error message text that goes with SQLCODE. |
| Exit | Exit from SQL Error Message tool. |
To display text that goes with a SQLCODE, do the following:
Copyright © 1999 MERANT International Limited. All rights reserved.
This document and the proprietary marks and names
used herein are protected by international law.
| Generate Alias | SQL Query | |