Values not matching between source table and ERROR table

Database
Highlighted
New Member

Values not matching between source table and ERROR table

I created an ERROR TABLE as below:

create multiset table dbname.et_poc
(
a number(18,6),
b number(18,6),
k number(18,6),
c INTEGER,
d INTEGER,
e INTEGER,
f INTEGER,
g DATE FORMAT 'YYYY-MM-DD',
h DATE FORMAT 'YYYY-MM-DD',
i DATE FORMAT 'YYYY-MM-DD',
j DATE FORMAT 'YYYY-MM-DD'
CONSTRAINT z CHECK ( C IS NOT NULL ),
CONSTRAINT y CHECK ( d is NOT NULL ),
CONSTRAINT x CHECK ( NOT (e IS NULL ) ),
CONSTRAINT w CHECK ( NOT (f IS NULL ) ),
CONSTRAINT v CHECK ( NOT (g IS NULL ) ),
CONSTRAINT u CHECK ( NOT (h IS NULL ) ),
CONSTRAINT t CHECK ( NOT ( j IS NULL ) ),
CONSTRAINT s CHECK ( NOT (i IS NULL ) ));

 

create error table dbname.et_et_poc FOR dbname.et_poc;

After insert as below,

ins into dbname.et_poc
sel a,b,
k,
c,d,e,
f,g,
h,
i,
j
from dbname.tab_name logging all errors with no limit;

 

ins into dbname.et_poc
sel a,b,
k,
c,d,e,
f,g,
h,
i,
j
from dbname.tab_name logging all errors with no limit;

 

Column a and b is null for all records in error table.  Although the source table has not null data. 

error_table_records.jpg              src_table_data.jpgcolumn C is same as K column in error table

Can someone pls help