Hi!
When trying to import data with TIMESTAMPs and a user-defined format,
repmcli/loadercli complains about the format. The easiest way is a little
example:
DATALOAD TABLE TEST
UPDATE DUPLICATES
"ID" 1
"VALUE" 2
INFILE '/tmp/repmcli/TEST-import.data'
COMPRESSED
ASCII SEPARATOR ';'
DELIMITER ''
TIMESTAMP 'DD MMM YYYY HH:MM:SS'
Note that the timestamp in the data-file has following format (current
date):
"01 Dec 2005 12:50:00"
Here's the output of repmcli:
---8<---
User DBA connected to database TEST on localhost.
DATALOAD TABLE TEST
UPDATE DUPLICATES
"ID" 1
"VALUE" 2
INFILE '/tmp/repmcli/TEST-import.data'
COMPRESSED
ASCII SEPARATOR ';'
DELIMITER ''
TIMESTAMP 'DD MMM YYYY HH:MM:SS'
Successfully executed:
-25301
Invalid input for date or time column: 01 Jan 2005 00:00:00
---8<---
Here's my test-data:
---8<---
01 Jan 2005 00:00:00;1
01 Feb 2005 00:00:00;2
01 Mar 2005 00:00:00;3
01 Apr 2005 00:00:00;4
01 May 2005 00:00:00;5
01 Jun 2005 00:00:00;6
01 Jul 2005 00:00:00;7
01 Aug 2005 00:00:00;8
01 Sep 2005 00:00:00;9
01 Oct 2005 00:00:00;10
01 Nov 2005 00:00:00;11
01 Dec 2005 00:00:00;12
---8<---
So I thought, that maybe a export reveals the solution for this problem:
repmcli-output:
---8<---
User DBA connected to database TEST on localhost.
DATAEXTRACT
"ID", "VALUE" FROM "TEST"
OUTFIELDS
"ID" 1
"VALUE" 2
OUTFILE '/tmp/repmcli/TEST-export.data'
COMPRESSED
ASCII SEPARATOR ';'
DELIMITER ''
TIMESTAMP 'DD MMM YYYY HH:MM:SS'
Successfully executed
---8<---
And here's the exported data:
---8<---
30 ... 1999 15:23:10;3
30 ... 2005 22:00:00;0
---8<---
There are really three dots ('...'). Am I missing something or what's going
wrong here?
Thanks for your help!
Cheers,
Chris
phone: +49 6898/10-4987
fax: +49 6898/10-54987
http://www.saarstahl.de
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
