IBM VERSION 9 Displaying SQL state help from the command line processor, Procedure, Related tasks

Models: VERSION 9

1 109
Download 109 pages 12.57 Kb
Page 91
Image 91
Displaying SQL state help from the command line processor

Note: The most up-to-date and complete DB2 documentation is maintained in the DB2 Information Center at http://publib.boulder.ibm.com/infocenter/ db2help/.

Procedure:

To order printed DB2 books:

vTo find out whether you can order printed DB2 books online in your country or region, check the IBM Publications Center at http://www.ibm.com/shop/ publications/order. You must select a country, region, or language to access publication ordering information and then follow the ordering instructions for your location.

vTo order printed DB2 books from your local IBM representative:

Locate the contact information for your local representative from one of the following Web sites:

-The IBM directory of world wide contacts at www.ibm.com/planetwide

-The IBM Publications Web site at http://www.ibm.com/shop/ publications/order. You will need to select your country, region, or language to the access appropriate publications home page for your location. From this page, follow the About this sitelink.

When you call, specify that you want to order a DB2 publication.

Provide your representative with the titles and form numbers of the books that you want to order.

Related concepts:

v“Overview of the DB2 technical information” on page 79

Related reference:

v“DB2 technical library in hardcopy or PDF format” on page 80

Displaying SQL state help from the command line processor

DB2 returns an SQLSTATE value for conditions that could be the result of an SQL statement. SQLSTATE help explains the meanings of SQL states and SQL state class codes.

Procedure:

To invoke SQL state help, open the command line processor and enter:

?sqlstate or ? class code

where sqlstate represents a valid five-digit SQL state and class code represents the first two digits of the SQL state.

For example, ? 08003 displays help for the 08003 SQL state, and ? 08 displays help for the 08 class code.

Related tasks:

v“Invoking command help from the command line processor” in Command Reference

v“Invoking message help from the command line processor” in Command Reference

Appendix E. DB2 Database technical information 83

Page 91
Image 91
IBM VERSION 9 Displaying SQL state help from the command line processor, Procedure, Related concepts, Related reference