Hi Danny, Danny Tramnitzke [mailto:[EMAIL PROTECTED]] wrote: > > 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 . > Nope. Of course not. It must not be in any case INTERNAL. You could specify SET DATE INTERNAL and it would have worked. You could specify any of the predefined formats EUR, ISO, JIS, USA or INTERNAL. Free formats for date and time and timestamp columns may only be specified (as already stated out of the list to Panos) in a certain command as in
DATALOAD TABLE <table name> <col specs> ... INFILE <infile name> DATE 'DD.MM.YYYY' The problem Panos was faced is a bit different (I think), though. He was trying to insert date values of format DD.MM.YYYY into a varchar(8) column. That won't work with RepMan/Loader because a 10 char long string cannot be inserted into a varchar(8) column. Dates are transformed from external format (which means the format of the fields in the data file and specified in the command file) to internal DB format (which is in any case INTERNAL) only if loaded into date columns. Regards, Steffen -- Steffen Schildberg SAP DB Team SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
