var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: DB2 IMPORT from ASC file fails using DATEFORMAT
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.
db2 "import from input.asc of asc modified by dateformat=\"YYYY-MM-DD\" method L (1 10) insert into tdate(ttdate)"
Thanks a ton Mark!
After including the escape character (\) before the double quotation it is working now!