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 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.
Last modified date: 01/29/2015