|
See Also
Before you can use
user-defined tables, you must do the following:
|
·
|
Create the tables in the RDBMS. |
|
·
|
Optimize performance by defining indexes and storage parameters
on the tables. |
|
·
|
Make sure that every user table in the RDBMS matches the
definition of the corresponding external set in the USoft
repository: |
|
·
|
The number of columns in the table must be equal to the number
of elements in the external set (including any virtual
elements). |
|
·
|
The column names must match the names of the external set
elements. |
|
·
|
The data type of every external set element must be a data type
which is supported by your RDBMS. |
|
·
|
The data type of every column must be equal to the data type of
the corresponding external set element. |
|
·
|
If a column width is associated with the data type, the column
width must be equal to the length of the corresponding element in
the external set. |
|
·
|
The database table must not have mandatory or NOT NULL
columns. |
|
·
|
Make sure that multiple batch jobs running simultaneously use
different user tables. |
|
