OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
 
loader date field issue

From: Tony Shamshad - Home Office (tony.shamshadmascocs.com)
Date: Tue Jul 05 2005 - 04:04:40 CDT


I am working on trying to import a TEXT file with a date field.
Following is just to demonstrate the issue. I have taken the 3 field
from a very large import file just to demonstrate the issue.

Source file:
1|water tower|06/30/05

.dat file:

DATALOAD TABLE TEST
        "ID" 1
        "FNAME" 2
        "ENTRY" 3 DEFAULT NULL

INFILE 'a.txt' SEPARATOR '|' DATE USA

"ENTRY" field need to be a date, when I set it to be a varchar, the load
works fine, as soon as I change it to a DATE field in the Destination
Table I get the following message.

DATALOAD TABLE TEST
        "ID" 1
        "FNAME" 2
        "ENTRY" 3 DEFAULT NULL
INFILE 'a.txt' SEPARATOR '|' DATE USA
Error during execution
-->-25301
Invalid input for date or time column: 06/30/05

Defined maximum number of errors (1) reached


1 error(s) while processing command file 'a.dat'.
---> See Loader protocol for more information.

I HAVE DONE THAT WITH DEFAULT AND WITH OUT ALSO WITH DATE USA AND WITH
OUT IT.

PLEASE ADVICE.

Thank you,


Tony


DISCLAIMER:
The information in this electronic mail message is sender's business Confidential and may be legally privileged. It is intended solely for the addressee(s). Access to this Internet
electronic mail message by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance
on it is prohibited and may be unlawful. The sender believes that this E-mail and any attachments were free of any virus, worm, Trojan horse, and/or malicious code when sent. This
message and its attachments could have been infected during transmission. By reading the message and opening any attachments, the recipient accepts full responsibility for taking
protective and remedial action about viruses and other defects. MASCO is not liable for any loss or damage arising in any way from this message or its attachments.