Embedded SQL Programming Guide
The DB2 SDK Building Applications book for your operating platform 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 the 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 for MVS/ESA or 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 instance,
print all the messages during the testing phase. See the API Reference for information about APIs.
[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]
[ DB2 List of Books |
Search the DB2 Books ]