Dear all,
I have a table that contains a DATE in char(10) format. This table is
LOADed.
I put a check constraint on the column, some kind of CHECK (DATE(F) <=
DATE('9999-12-31'))
and I would like to move badly formatted field to the exception table.
The problem is I will always get SQL0180N and the record is not moved into
the exception table when I issue a SET INTEGRITY command.
Is there any trick to do the job - I am interested in moving the field to
the exception table and not let the LOAD reject the fields in a dump file
(that would be the case with a DATE field instead of a CHAR(10)).
Thanks for your help,
Jean-Marc