when i try this command:
import from test.txt of del modified by coldel0x09 dateformat="DD-MMM-YY" insert into stat_test
i always get the warning message:
SQL3129W The date, time, or timestamp field containing "12-DEC-00" in row "5"
and column "35" was padded with blanks.
because my file:test.txt contain one column(column "35") is like "12-DEC-00",
my question is how can i set dateformat to make my import operation be succeed?
YYYY - Year (four digits ranging from 0000 - 9999)
M - Month (one or two digits ranging from 1 - 12)
MM - Month (two digits ranging from 1 - 12; mutually exclusive with M)
D - Day (one or two digits ranging from 1 - 31)
DD - Day (two digits ranging from 1 - 31; mutually exclusive with D)
DDD - Day of the year (three digits ranging from 001 - 366; mutually exclusive with other day or month elements)
Some examples of date formats are:
You will have to present "12-DEC-00" in the form of "12/12/2000" or something similar to DB2 before you can load those records.
With kind regards . . . . . SQL Server 2000/2005/2012
Grabel's Law: 2 is not equal to 3 -- not even for very large values of 2. Pat Phelan's Law: 2 very definitely CAN equal 3 -- in at least two programming languages