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