Hi Tomas, Tomas Simecek [mailto:[EMAIL PROTECTED] wrote: > > I am trying following command: > DATAEXTRACT FOR DATALOAD TABLE TEST_AUTH > OUTFILE 'TEST_AUTH.control' > OUTFILE 'TEST_AUTH.data' > > It creates for me these two files filled with datas. But then > I want to > import data again. When I run: > // > DATALOAD TABLE "TEST_AUTH" > "I1" 1 CHAR DEFAULT NULL > "T1" 2 CHAR DEFAULT NULL > "USER_CREATED" 3 CHAR DEFAULT NULL > "TIME_CREATED" 4 CHAR DEFAULT NULL > "USER_MODIFIED" 5 CHAR DEFAULT NULL > "TIME_MODIFIED" 6 CHAR DEFAULT NULL > "CRC" 7 CHAR DEFAULT NULL > INFILE 'TEST_AUTH.data' > COMPRESSED ASCII > DECIMAL '/ /./' > DATE INTERNAL > TIME INTERNAL > TIMESTAMP INTERNAL > NULL '? ' > BOOLEAN 'TRUE/FALSE' > // > This is part of the TEST_AUTH.control file, first statement for > creating table I deleted. > > It still gives me error: "Invalid input for date or time column: > 2003-06-05 11:45:58. " > What I am doing wrong ? There is specified that timestamp is > INTERNAL, > also adding TIMESTAMP INTERNAL to the first command doesn't help. > What's the version you use? There is a tiny little problem within the Loader server. It expects the time/date/timestamp format from kernel as INTERNAL. But I would expect that your db kernel parameter DATE_TIME_FORMAT is set to ISO, right. You could do now 2 alternative things as a workaround. 1. Set the db kernel parameter to INTERNAL run the extract again and the load will succeed. or 2. Modify your load command to ... TIMESTAMP 'YYYY-MM-DD HH:MM:SS.NNNNNN' ... This should work with the extract you already have.
We'll correct the problem asap. Sorry for any inconvenience. Regards, Steffen -- Steffen Schildberg SAP DB Team SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
