Hi Suraj, Suraj Panicker [mailto:[EMAIL PROTECTED] wrote:
> Subject: Data Import with Date Fields > > I'm trying to import data into a database table which has > date fields. It > gives me some problems. Here are the details : > > >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> > Here's the import.command file : > -------------------------------- > <snipped some content of the command file> > // > // > DATALOAD TABLE resources > INFILE 'resources.txt' > DELIMITER '|' > >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> > > >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> > Here's the resources.txt file : > ------------------------------- > > 1|5/14/2003|5/14/2003,0,0,portal.title,portal,Portal Entry Page > > >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> > <snipped some output and table definition> > > DATALOAD TABLE resources > INFILE 'resources.txt' > DELIMITER '|' > Error during execution > -->-25319 > Missing data for specified column CREATETIMESTAMP. > > > The dates I enter are in the USA format mm/dd/yyyy. Is there > anything I'm doing wrong ? > You mixed separators and delimiters. Modify your command to let the Loader accept '|' as separator and 'empty' delimiters as follows: DATALOAD TABLE resources INFILE 'resources.txt' DELIMITER '' SEPARATOR '|' And you can't have different separators in one data file. So according to the command above your resources.txt file should look like this: 1|5/14/2003|5/14/2003|0|0|portal.title|portal|Portal Entry Page Or you change the command to have default separators and no delimiters: DATALOAD TABLE resources INFILE 'resources.txt' DELIMITER '' Then the resources.txt file should look like this 1,5/14/2003,5/14/2003,0,0,portal.title,portal,Portal Entry Page Regards, Steffen -- Steffen Schildberg SAP DB Team SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
