Defining a Reject Table

Previous Next

If you want to use a reject table, you need to define it in USoft Definer. A reject table is a duplication of an application table.

However, some duplicated columns might be based on different domains from those used by the application table, because domain constraints and other implicit rules defined at domain level must not apply to the reject table.

It is suggested that you define a number of dummy string domains ("description" domains) of different lengths. Reserve these domains for reject columns.

To define a reject table:

1.Determine what dummy string domains you need, and define them.
2.Define a new domain that will generate unique numerical values for the primary key of the reject table.
3.Determine if you want any additional information in the reject table, such as a timestamp. Define new domains where necessary.
4.Define the reject table and its columns. Columns should include:

Numerical primary key column based on the newly defined domain.

One duplicated column for each application column. Each duplicated column must be based on a dummy (string) domain without domain constraints.

Any additional columns such as a timestamp.

5.Have the reject table implemented by choosing Tools, Create Physical Tables (option New or Updated) from the Definer menu bar.