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.
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
