Joined: 02 Mar 2011 Posts: 1 Location: Chennai, India
I have written a DB2 load utility that loads a tab delimited file ftpd from SQL server. For one of the columns defined as VARCHAR in DB2, we receive data with a quotation mark in the beginning (") without an ending quote. The load utility throws a delimiter mismatch error and rejects this record.
I have following two questions:
1. Is there an option in DB2 Load to avoid the default CHARDEL value (")? I saw that DB2 unload utility has an option 'NOCHARDEL' but an option in LOAD.
2. Also is there a way to make the utility skip the problematic column and load rest of the columns instead of skipping the entire row?
input row "QTR RND WM11 BAM 12X13X4
Error message DSNU1143I DSNURILD - RECORD 156058 WILL BE DISCARDED DUE TO DELIMITER MISMATCH FOR COLUMN NAME