Kbase P10980: error 80 during data load
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
5/10/2004 |
|
Status: Unverified
SYMPTOM(s):
** The month of a date must be from 1 to 12. (80)
During data load (bulkload)
At the end of ".d" file: dateformat=dmy-1920
CAUSE:
The format used to display dates needs to be the same during the load and the dump.
FIX:
Start client session with additional startup parameter "-d dmy".
Most probably the format for the numeric values in that ".d" file is the European one, i.e. with commas as decimal points. If so, then you will need to add the startup parameter "-E" for loading.