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.