Hi Panos and the others > > Now I'm getting into a different situation: > > > > My source files contain dates in "DD.MM.YYYY" format, whereas > > the equivalent > > date fields of my target tables are in "YYYYMMDD" format. How > > do I convert date information from source format to target one? > > > Hmm, may be I don't get it right. But thats the work RepMan does for > you. The format YYYYMMDD is the normal internal date format of the db > (called INTERNAL) and the RepMan will convert any recognized external > format (means: stored in data files and specified in commands) to the > internal db format. Actually no additional work necessary from your side. > > Regards, > Steffen
I had the same problem, that you have with date formats and repmcli . I also have tried the SET DATE statement and the DATE 'YYYYMMDD' , but nothing worked, only when I load INTERNAL formats form source to targed table. So the date in the source file must be INTERNAL . For that I (had to write) have written a small additional tool, wich translate my date, time and timestamp format from 'MON DD YYYY' (sybase) to 'YYYYMMDD' (sapdb internal), and write it into a new bcp-file. Now I haven't such problems anymore ... So, when know how to programm, such a functionality takes only a few ours ... -- +++ GMX - Mail, Messaging & more http://www.gmx.net +++ Bitte l�cheln! Fotogalerie online mit GMX ohne eigene Homepage! _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
