IBM Books

SQLSTATE

This box displays SQLSTATE values. These values are to be interpreted as successful executions. To add values to this list, click on Add to open the Add SQL window.

After an SQL statement is processed, a subscription will fail on a nonzero SQLSTATE, unless you specifically list a nonzero SQLSTATE in the SQLSTATE box. For example, if you enter 02000 as an acceptable SQLSTATE, your subscription will not fail while executing SQL-BEFORE or SQL-AFTER statements.

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

[ DB2 List of Books | Search the DB2 Books ]