Database Guide


Database Package Specifications

Use the Database Package Specifications window to create a static query. To use this window, follow these steps:

  1. From the Access Set drop-down list, select an access set.

    For the sample application, select SampleDatabaseAccessSet.

  2. From the Connection Alias drop-down list, select the Connection specification for your application.

    For the sample application select SampleConSpec.

  3. In the Package Name field, type a package name.

    For the sample application, type SampleDatabaseStaticPackage.

  4. 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.
  5. 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 ]