Online help is available with all DB2 components. The following table
describes the various types of help.
| Type of Help |
| Contents | How to Access... | ||
|---|---|---|---|---|---|
| Command Help |
| Explains the syntax of commands in the command line processor. | From the command line processor in interactive mode, enter:
? command where command is a keyword or the entire command. For example, ? catalog displays help for all the CATALOG commands, whereas ? catalog database displays help for the CATALOG DATABASE command. | ||
| Control Center Help |
| Explains the tasks you can perform in a window or notebook. The help includes prerequisite information you need to know, and describes how to use the window or notebook controls. | From a window or notebook, click on the Help push button or press the F1 key. | ||
| Message Help |
| Describes the cause of a message number, and any action you should take. | From the command line processor in interactive mode, enter:
? message number where message number is a valid message number. For example, ? SQL30081 displays help about the SQL30081 message. To view message help one screen at a time, enter: ? XXXnnnnn | more where XXX is the message prefix, such as SQL, and nnnnn is the message number, such as 30081. To save message help in a file, enter: ? XXXnnnnn > filename.ext where filename.ext is the file where you want to save the message help.
| ||
| SQL Help |
| Explains the syntax of SQL statements. | From the command line processor in interactive mode, enter:
help statement where statement is an SQL statement. For example, help SELECT displays help about the SELECT statement. | ||
| SQLSTATE Help |
| Explains SQL states and class codes. | From the command line processor in interactive mode, enter:
? sqlstate or ? class-code where sqlstate is a valid five digit SQL state and class-code is a valid two digit class code. For example, ? 08003 displays help for the 08003 SQL state, whereas ? 08 displays help for the 08 class code. |