Datalink objects  ODL functions

Chapter 1: Overview

Table objects

Table objects contain one or more data columns that you use to specify which data should go into the output transaction. Field data that matches a value in the designated search column of the table is replaced with the corresponding values in the specified columns.

Use table objects in filter or qualification objects. When used in a filter object, you specify within the filter which table column in which to search for a match to the data passed to the filter. You also specify which columns’ corresponding values to place into the output transaction when data matches the search column.

When used in a qualification object, you also specify within the qualification object which table column in which to search for a match to the data passed to the qualification object. If the data does not match, then the qualification object fails.

In most cases, you want to build special or custom tables before you define the filter objects that will use the tables.

See “Creating table object filters” for more information on using tables.





Copyright © 2005. Sybase Inc. All rights reserved. ODL functions

View this book as PDF