Database Guide
Use the Database Package Specifications window to create a static
query. To use this window, follow these steps:
- From the Access Set drop-down list, select an access
set.
For the sample application, select
SampleDatabaseAccessSet.
- From the Connection Alias drop-down list, select the Connection
specification for your application.
For the sample application select SampleConSpec.
- In the Package Name field, type a package name.
For the sample application, type
SampleDatabaseStaticPackage.
- Select Save. A package spec must be saved before you can
precompile it. The last saved version of the package is
precompiled. See the VisualAge User's Guide for
information on precompiling your package spec.
- On the Multi-row Query settings window, select the Package Name for the
package you created, then select OK. The queries for the
Multi-row Query part are added to the package.
- Note:
- When you apply the settings for an updatable part, VisualAge automatically
generates queries that are required for runtime, stores them in the access
set, and adds them to the package. If you add queries to a package
specification manually, the automatically generated queries will not be
included in the package. If you are using VisualAge parts, you should
let the Multi-row Query settings manage the package for you.
It is a good idea to finish your application and test it before
precompiling packages. After you finish the sample application and test
it, precompile the package spec and try testing again.
[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]