Fastload date format/default problem

[WILLIEWANKA]

I've got a delimited text file with some fields being 8 character date fields (mm/dd/yy). I've set the create table statement to DATE FORMAT 'MM/DD/YY' and it loads fine. The problem is that it dafaults the century to 1900 instead of 2000.

So if I have a date of 09/10/03, it will load it as 1903-09-10

Is there any way to make that 2003-09-10?

 

[dnoeth]

You can't do that with FastLoad, you'll have to use MultiLoad instead.
But there's a global switch your DBA may set, the CenturyBreak (dbscontrol General Field 14):
E.g. if it's set to 20 then 00 to 19 will be 2000 to 2019 else 19xx

Dieter