Syteline v6.03 / Progress v10.2B
After a failed (binary) dump / load, I am trying to work through the dump / load (ASCII) procedure recommended by Infor (slow - but it works).
They recommend that the database is running multi-user - and data administration is accessed through Syteline. From the admin menu, dump the df, dump .d files. The PF files that I am using to start the database use -yy 1930.
When I use data administration to load the data, I get this error:
>> ERROR! -d <mdy> or -yy <n> settings of dump were mdy-1930
** but current settings are mdy-1950. May cause load errors.
I expected to find -yy = 1950 in the DLC/startup.pf but don't see it there. Searching for files containing -yy I don't find anything with 1950 in it.
Where can I find / change the default setting for yy?
I am pretty sure there are no dates in the database older than 1950. What happens to my data if I change the yy parameter to 1950 - or eliminate it all together?
When you dump (ASCII) OE will write -yy setting in the .d file
dateformat=mdy-1950
map=NO-MAP
cpstream=ISO8859-1
.
0000012944
It is likely that the process that dumped it for you did not use any -yy and thus you got the default value 1950.
You better use the same value to load -yy 1950 or not use this parameter which means the same value.
Eliminating it means you will use the default value 1950 -- which is exactly what you need in that case.
Well that's exactly what I thought. Thank you.
If you can't use binary dump/load, I suggest to connect both source and target database and use buffer-copy between them. It's faster and you have no problems with these parameters.
Adriano.