Database Guide

Precompiling static SQL

Now is also a good time to go back and precompile the static database queries for this application. To precompile queries, do the following:

  1. From the Options menu in the VisualAge Organizer, select Database Package Specs.
  2. On the Database Package Specifications window, use the drop-down lists to select the access set, connection alias, and package name for your application.
  3. Select Precompile. The last saved version of the package is precompiled. If you make any changes to a package, save it before precompiling.

The SQL statements for the queries in the package are precompiled. Now try testing your application again.


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