I'm trying to load from a csv file to DB2 and one of the columns is a date. The date values are in the format MM/DD/YYYY.

The code is:
LOAD FROM "C:\file.csv" OF del MODIFIED BY usedefaults MESSAGES "C:\load_log.txt" INSERT INTO xTable

I get error "SQL0180N The syntax of the string representation of a datetime value is incorrect. SQLSTATE=22007"

Then I tried the dateformat modifier but the exact same error occurs!
LOAD FROM "C:\file.csv" OF del MODIFIED BY dateformat="MM/DD/YYYY" usedefaults MESSAGES "C:\load_log.txt" INSERT INTO xTable

Help!!