Creating Table Descriptors from Table Instances and Simultaneously Mapping Them

If the Table instance you need to read from or write to already exists in Oracle LSH, you can create a Table Descriptor from the Table instance. The system bases the Table Descriptor on the same Table definition the Table instance is based on, and automatically maps the new Table Descriptor to the Table instance.

You can use this method to create multiple Table Descriptors at the same time from Table instances located in a single Work Area.

This is the only method where the system creates a source Table Descriptor by default. You can change the setting to Is Target if necessary.

Note:

You can create target Table Descriptors only from Table instances in the same Work Area as the Program.

To create a Table Descriptor from an existing Oracle LSH Table instance, do the following:

1. In the Program's Properties screen, select Table Descriptors from Existing Table Instances from the Actions drop-down list and click Go.

   The Create Table Descriptors from Table Instances screen opens.

2. Select the location of a Table instance for which you want to create a Table Descriptor:

   • Select the Table instance's Domain from the Domain drop-down list.

   • Select the Table instance's Application Area from the Application Area drop-down list. The choices are limited to Application Areas contained in the Domain you selected.

   • Select the Table instance's Work Area from the Work Area drop-down list. The choices are limited to Work Areas contained in the Application Area you selected.

3. Click Go. The system displays all the Table instances in the Work Area you selected.

   Note:

   A Table instance can be mapped to only one Table Descriptor in a Program instance. In addition, only one Program instance can write to a particular Table instance. You get an error if you select a Table instance whose selection would violate either of those rules.

4. Select one or more Table instances by clicking the Select checkbox.
5. Click Create Table Descriptor. The system returns you to the Create Table Descriptors from Table Instances screen. To return to the Program's Properties screen, click Return. Check that the mappings are complete.