Data Import with Date Fields
"Suraj Panicker" <[email protected]> Mon, 25 Aug 2003 14:10:46 +0530
| Newsgroups | gmane.comp.db.sapdb.general |
|---|---|
| Message-ID | <[email protected]> |
Hello, I'm trying to import data into a database table which has date fields. It gives me some problems. Here are the details : I used the command : repmcli -E 0 - b import.command >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> Here's the import.command file : -------------------------------- AUTOCOMMIT ON // SQLMODE ORACLE // USE SERVERDB sampledb // USE USER user password // SET DATE USA // // 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 >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> Here's the table column spec : ------------------------------ CREATE TABLE Resources ( ResourceId NUMBER(38) NOT NULL, CreateTimeStamp DATE NOT NULL, UpdateTimeStamp DATE NOT NULL, UpdateCounter NUMBER(38) NOT NULL , Deleted NUMBER(38) NOT NULL , ResourceKey VARCHAR2(400) NOT NULL , Category VARCHAR2(200) NOT NULL , Description VARCHAR2(1000) NOT NULL ) >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> Here's output of repmcli : -------------------------- D:\Program Files\sapdb\programs>repmcli -E 0 -b import.command Loader Server Protocol File: 'd:\program files\sapdb\indep_data\wrk\loader.pr t' AUTOCOMMIT ON Successfully executed SQLMODE ORACLE Successfully executed USE SERVERDB sampledb Successfully executed USE USER user password Successfully executed SET DATE USA Successfully executed DATALOAD TABLE resources INFILE 'resources.txt' DELIMITER '|' Error during execution -->-25319 Missing data for specified column CREATETIMESTAMP. 1 error(s) during execution of command file 'import.command'. ---> See log file(s) for more information. >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> The dates I enter are in the USA format mm/dd/yyyy. Is there anything I'm doing wrong ? Thanks in advance, Suraj.