RE: Data Import with Date Fields

Hello Suraj,

perhaps my following tip is useful fo you. If use insert the following
command line into your script:

//
ALTER SESSION SET nls_date_format = 'MM/DD/YYYY'
//

Possibly this will fix your problem...

Best regards
Hans-Joachim Görke
Königstr. 16
D-42781 Haan
mailto:[email protected]

> -----Ursprüngliche Nachricht-----
> Von: [email protected]
> [mailto:[email protected]]Im Auftrag von Suraj
> Panicker
> Gesendet: Montag, 25. August 2003 10:41
> An: [email protected]
> Betreff: Data Import with Date Fields
>
>
> 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
>
>