DB2 Server for VSE & VM: Application Programming

Chapter 6. Testing and Debugging

Partial Table-of-Contents

Doing Your Own Testing

Checking Warnings and Errors at Preprocessor Time

Testing SQL Statements

Using the Automatic Error-Handling Facilities

Using the SQLCA

Using the SQLERRM Field

Using the SQLWARN Field

Examining Errors

Using the WHENEVER Statement

Determining the Scope of the WHENEVER Statement

Examining the SQLCA

Using TEXT Files to Get SQLCA Field Information

Handling Errors in a Select-List

Handling Arithmetic Errors

Handling Numeric Conversion Errors

Handling CCSID Conversion Errors

Contents

[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]