Hi Panos,

PanosPlaton@HoTMaiL [mailto:[EMAIL PROTECTED]] wrote:
> 
> 
> Steffen, thanks very much for the info. However, putting the 
> command "SET
> DATE EUR" (or "SET DATE 'DD.MM.YYYY'") into the command file 
> produces the following error:
> 
> "E -25281: Syntax error at position 10 (Unexpected keyword: EUR /
> 'DD.MM.YYYY')".
> 
Ok, now the next question: what version do you use. For that see the
repserver.log. It is important to know the whole version information, e.g.
7.3.XX.XX.

> In brief it seems like Replication Manager completely ignores 
> the "SET DATE"
> command (quite strange, isn't it?...).
> 
Indeed it is.

> 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
-- 
Steffen Schildberg
SAP DB Team
SAP Labs Berlin
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general

Reply via email to