Preparing to Use User-Defined Tables
Before you can use user-defined tables, you must do the following:
•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.