Adding an Association

The content of the AE schema is made up of five parts: associations, classes, scalars, sequences, and unions. If you use parent-child relationships for Publication Service, you have to add an association to the metadata stored in the AE schema.

Procedure

  1. In the AE Schema editor, click the Associations tab.
  2. Select a parent-child association. Several associations are displayed in the All Associations panel, at least one for the parent table with a child table.
  3. In the Configuration panel, replace the name of the publishing table with the name of the reference object in the Name field.
  4. Expand the parent-child association in the All Associations panel and select Left Association.
  5. In the Configuration panel, specify the following fields and keep the rest fields unchanged:
    • Name: Replace the name of the publishing table with the name of the reference object.
    • Endpoint Class: Click Browse. In the Schema Selection window, select the schema of the adapter configuration. In the displayed list, select the reference object, VIEW_PA1. Click OK.
  6. In the All Associations panel, select Right Association.
  7. In the Configuration panel, repeat Step 5 to specify the right association.
  8. Save the AE schema.

Table to Record Sequence Numbers (DB2 on iSeries)

The palette attempts to create a table (if it does not exist) to record sequence numbers.

A table is created by using the following statement: 

CREATE TABLE library.ADB_SEQTAB (
PUB_TABLE VARCHAR(64) NOT NULL,
ADB_SEQ NUMERIC(20),
constraint ADB.ADB_SEQTAB_KEY primary key (PUB_TABLE))

The table must be journalled.

You can create this table manually. If journalling is automatically turned on, the palette creates the table automatically.

Contents
Search Results