DB2 expects the deliimiter to be a single byte.
Your delimiter appears to be three bytes.
Pre-process the file (e.g. in Perl, or with cygwin awk or tr) to replace the three-bytes by a single byte-character that you already verified is not part of any of the data.
You can use non-printable character for the delimiter, specifiy it with a 0x as a hex code to the COLDEL.
If i want to use non ascii character like ж as delimiter..how can i do that. The data i am working on is of poor quality thats why had used three byte delimiter earlier. using non ascii character as alternative helps decrease chance of it being non unique.
Choose a byte that is not already in the data.
Verify with a search tool that the chosen byte is absent from the file.
Suppose (for example only) that you chose 0xAC as the delimiter.
You verified that this byte does not appear in the file.
You can either re-create the CSV file using 0xAC as the delimiter
or you can pre-process your existing file (with awk, Perl, tr , sed etc) to convert each sequence of your old 3-byte-delimiter to the new chosen single-byte-delimiter (example 0xAC).
Then use .. MODIFIED BY...COLDEL 0xAC ...
It is only an example, just choose any single-byte character that is verifably absent from the data, or used fixed-width (non-delimited) files indead (if you are using a fixed-size encoding, of course).
try to find the dba in your company or if none, try to hire a consultant that can help and even teach you how todo this in the future.. (not for free of course)
Best Regards, Guy Przytula
Database Software Consultant
Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
Information Server Datastage Certified http://www.infocura.be