Hi all
Ok,
DATE 'DD.MM.YYYY'
workes fine, but how to make it with timestamp values ?
I have a command file :
Create table datetest (
nr smallint,
name char(50),
heute date
)
//
DATALOAD table datetest
nr 1
name 2
heute 3
INFILE '/home/sapdb/datetest.inp'
DATE 'YYYY-MM-DD-HH.MM.SS.MMMMMM'
SEPARATOR ','
DELIMITER ''
and the input file :
1,Holger,1999-01-23-14.30.08.456234
2,Achim,2003-02-19-10.06.50.123456
But here comes the Errormessage :
Error during execution
-->-25301
Invalid input for date or time column: 1999-01-23-14.30.08.456234
Defined maximum number of errors (1) reached
maybe I have to take an other Statement instead of 'DATE', or an other
column datatype ?
regards
Danny
> Nope. Of course not. It must not be in any case INTERNAL.
> You could specify SET DATE INTERNAL and it would have worked.
> You could specify any of the predefined formats EUR, ISO, JIS, USA
> or INTERNAL.
> Free formats for date and time and timestamp columns may only be
> specified (as already stated out of the list to Panos) in a certain
> command as in
>
> DATALOAD TABLE <table name>
> <col specs>
> ...
> INFILE <infile name>
> DATE 'DD.MM.YYYY'
>
> The problem Panos was faced is a bit different (I think), though.
> He was trying
> to insert date values of format DD.MM.YYYY into a varchar(8) column.
> That won't work with RepMan/Loader because a 10 char long string cannot
> be inserted into a varchar(8) column. Dates are transformed from
> external format (which means the format of the fields in the data file
> and specified in the command file) to internal DB format (which is in
> any case INTERNAL) only if loaded into date columns.
> Regards,
> Steffen
--
+++ GMX - Mail, Messaging & more http://www.gmx.net +++
Bitte l�cheln! Fotogalerie online mit GMX ohne eigene Homepage!
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
