Previous Topic: Edit SQL Column NamesNext Topic: Define the Basics

Creating Table Procedure Specifications › Define a Table Procedure Specification

Define a Table Procedure Specification

This section describes the steps required to define a table procedure specification using the Quick Bridge tool. They are:

  1. Define basic information about the table procedure, such as its name and the user database schema and subschema it will access.
  2. Select the entry record in the path.
  3. Select additional records in the primary path.
  4. Select the target record and fields for the table procedure.

To follow along using the Commonweather demo database installed with CA IDMS, create a data source that connects to the EMPSS01 subschema of EMPSCHM version 100. The table procedure specification that you will create in this section uses the DEPARTMENT, EMPLOYEE, EXPERTISE, and SKILL database records.

The database diagram following displays these records and their set relationships as defined for the Commonweather demo database:

This graphic shows records and their relationships.