Application Development Guide
The Application Building Guide tells you how to run your program in your environment. You can do
the following to help you during the testing and debugging of your code:
- Use the same techniques discussed in Prototyping Your SQL Statements. These include using the command line processor, the
Explain facility, analyzing the system catalog views for information about the
tables and databases your program is manipulating, and updating certain system
catalog statistics to simulate production conditions.
- Use the database system monitor to capture certain optimizing information
for analysis. See the System Monitor Guide and
Reference.
- Use the flagger facility to check the syntax of SQL statements in
applications being developed for DB2 Universal Database for OS/390, or for
conformance to the SQL92 Entry Level standard. This facility is invoked
during precompilation. For information about how to do this, see Precompiling, towards the end of the section.
- Make full use of the error-handling APIs. For example, you can use
error-handling APIs to print all messages during the testing phase. For
more information about error-handling APIs, see the Administrative API Reference.
[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]
[ DB2 List of Books |
Search the DB2 Books ]