Sure, I know that, because sapdb online documentation (http://www.sapdb.org/htmhelp/d7/efa654014c11d3a97d00a0c9449261/content.htm) tells, that in that case I have to take the datatype 'timestamp'
like this one : create table timestamptest ( test timestamp ) When I try this Statement in SQL-Studio7.4, there comes the Error : General error;-3002 POS(35) Invalid datatype. On the other Hand it will be successfully executed with repmcli (command-file), but also then! comes the Error while filling with data : 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 But, I have found out, that a DATE Column can also receive INTERNAL Timestamp Values, and I guess, that might be a possible way to going around that problem with timestamp-columns... So may be, you can give me a working commandfile(with table definition) for that case ? regards Danny > 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 -- +++ 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
