Preparing to Use User-Defined Tables

Before you can use user-defined tables, you must do the following:

1.	Create the tables in the RDBMS.

2.	Optimize performance by defining indexes and storage parameters on the tables.

3.	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.

4.	Make sure that multiple batch jobs running simultaneously use different user tables.