The input file has date as listed below:
Use of dateformat="YYYY-MM-DD" in the IMPORT command still fails with SQL3192N.
db2 "import from input.asc of asc modified by dateformat="YYYY-MM-DD" method L (1 10) insert into tdate(ttdate)"
"SQL3192N In the filetmod a user specified format "DATEFORMAT" beginning with the string "YYYY-MM-DD" is not valid."
Am I missing something here?
Thanks in advance.