Danny,
Danny Tramnitzke [mailto:[EMAIL PROTECTED]] wrote:
>
> Hi
>
> Thats the point : the following command-file
>
> Drop table datetest
> //
> Create table datetest (
> nr smallint,
> name char(50),
> heute date
> )
> //
> DATALOAD table datetest
> nr 1
> name 2
> heute 3
> INFILE '/home/sapdb/datetest.inp'
> TIMESTAMP 'YYYY-MM-DD-HH.MM.SS.MMMMMM'
> SEPARATOR ','
> DELIMITER ''
>
> didn't work ...
>
> 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
>
column heute is of data type date and you're intending to
insert a timestamp. That won't work. Data types of columns and
external types of data fields must have some relation, though.
Steffen
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
