ok, great ! it goes a step further :
I replaced FASTLOAD with DATALOAD the table has the colum "mod_stamp" with timestamp format the input.sql is the following : Cover,HEIGHT,19990123143008456234,I,user06 Cover,HEIGHT_UNIT,20010412170945040000,I,user06 the commandfile looked so : DATALOAD table toti106 media_type_key 1 media_attribute_key 2 mod_stamp 3 mod_flag 4 mod_user 5 INFILE '/home/sapdb/imput.sql' SEPARATOR ',' DELIMITER '' Errormessage : -->-25010 SQL error -3050 = Invalid timestamp format:INTERNAL (error position: 1) Thats a readable errormessage! ;-) I have tried : SET TIMESTAMP INTERNAL // DATALOAD table toti106 media_type_key 1 media_attribute_key 2 mod_stamp 3 mod_flag 4 mod_user 5 INFILE '/home/sapdb/shit.sql' TIMESTAMP 'yyyymmddhhmmssmmmmmm' SEPARATOR ',' DELIMITER '' But the Error now : Error during execution -->-25301 Invalid input for date or time column: 19990123143008456234 Question : What timestamp-format wants repmcli ? regards > Danny! > > Danny Tramnitzke [mailto:[EMAIL PROTECTED]] wrote: > > > > Ok, sorry for my fractional information. > > > > the whole Errormessage was "Error during execution > > -->SQL error -7050 = Fastload with indexed table not allowed (error > > position: 1)" > > > That's the normal behavior of FASTLOAD. The table to be loaded > must not have an index. The reason is that FASTLOAD builds the data > pages and sends them to the kernel (no sql insert stuff here). But > there is so far no possibility to recreate an index starting at a > certain record. The only way is to fully recreate the index. And that's > time consuming and in no relation to the amount of data loaded in > most of the cases (imagine a table that has 4 GB of data and you add > 3 rows with FASTLOAD and recreate the index - uuuh). > So to load those indexed tables use DATALOAD. The syntax is pretty much > the same - simply replace FASTLOAD with DATALOAD. > > Regards, > Steffen > -- > Steffen Schildberg > SAP DB Team > SAP Labs Berlin > _______________________________________________ > sapdb.general mailing list > [EMAIL PROTECTED] > http://listserv.sap.com/mailman/listinfo/sapdb.general > -- +++ 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
