|
See Also
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. |
|
