PreviousGenerate Alias SQL QueryNext"

Chapter 14: SQL Error Messages

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.

14.1 SQL Error Message tool

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:

14.2 The Toolbar

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.

14.3 The Menu Bar

The menu bar is another way of invoking SQL Error Message functions. The menu bar is composed of two menus: SQLCODE and Help.

14.3.1 The SQLCODE Menu

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.

14.4 Displaying an Error Message

To display text that goes with a SQLCODE, do the following:

  1. Enter SQLCODE that you want message for in SQLCODE entry field

  2. Click Run or select Display message from SQLCODE menu

Copyright © 1999 MERANT International Limited. All rights reserved.
This document and the proprietary marks and names used herein are protected by international law.

PreviousGenerate Alias SQL QueryNext"