I have CSV data coming from an external system which mainly puts quotes for those data which has comma(,) within it mainly to mask the commas as separate data columns.
For e.g.
Data has a layout as below
Emp id, Name , address Line 1 , Address Line 2 , Country, Pincode
So quotes occur dynamically based on occurrence of comma as data and not as a delimiter. I am using DB2 utility to load the data on a table. But during loading few of the data are getting rejected due to delimiter mismatch or length exceeding. So I thought to use 'Trimming' option during loading. But I want to know is there any option to identify the data which has been trimmed during DB2 table loading. As down the line I need to separate the erroneous data from correct ones.
As mentiioned earlier, the same load utility as below has been used, but I want to know, is there any option which can help me to find which data are trimmed and which data are loaded as it is?
LOAD DATA
FORMAT DELIMITED COLDEL ',' CHARDEL '"' DECPT '.'
INTO TABLE TABLE_NAME
(EMP_ID CHAR STRIP BOTH TRUNCATE,
EMP_NAME CHAR STRIP BOTH TRUNCATE,
EMP_ADDR1 CHAR STRIP BOTH TRUNCATE,
EMP_ADDR2 CHAR STRIP BOTH TRUNCATE,
CITY CHAR STRIP BOTH TRUNCATE,
ZIP_CODE CHAR STRIP BOTH TRUNCATE )