Not able to see the discarded records in error or uv table in fastload

Tools & Utilities
Enthusiast

Not able to see the discarded records in error or uv table in fastload

--
19,RAMESH,20,4700,2010-01-10
15,KUNU,30,7000,2010-01-11
15,KUNU,30,7000,2010-01-11
0,10,20,8000,4000
---

i wanted to load the above data from the file.
Only two records got inserted into the target table. But i am not able to see the last two records in the
error table or uv table

select count(1) from tempuser.ET_floademp;

*** Query completed. One row found. One column returned.
*** Total elapsed time was 1 second.

Count(1)
-----------
1

select * from tempuser.ET_floademp;
$
*** Failure 3798 A column or character expression is larger than the max si
ze.
Statement# 1, Info =0
*** Total elapsed time was 1 second.

select count(1) from tempuser.UV_floademp;
*** Failure 3807 Object 'tempuser.UV_floademp' does not exist.
Statement# 1, Info =0
*** Total elapsed time was 1 second.

1 REPLY
Enthusiast

Re: Not able to see the discarded records in error or uv table in fastload

ya..got it.. Duplicate records rejected are not stored in the UV error table.
error record is not stored in the ET error table.only the errorcode and error message etc are stored.

Thanks