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')". In brief it seems like Replication Manager completely ignores the "SET DATE" command (quite strange, isn't it?...). 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? I thought of a workaround to add "intermediate" columns in the definitions of the target tables, that will accept the date values in the "DD.MM.YYYY" format (during the data loads) and then add SQL commands into the command file (after the "DATALOAD" statements) that will convert the date values into "YYYYMMDD" format (using string manipulation functions). However, I think that the time overhead & complexity is going to become higher in the course of time (as the datasets get bigger in size and the db schema of the application becomes more complex) and I would like to have a simpler solution. Any suggestions? Panos Platon Tsapralis, SAP-R/3 Specialist, ABAP/4 Developer, Athens, GREECE, cell phone: +306936353566, telefax: +18019925665, [EMAIL PROTECTED], [EMAIL PROTECTED] ----- Original Message ----- From: "Schildberg, Steffen" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, 18 February, 2003 11:19 Subject: RE: Replication Manager: SET DATE command. > Hi Panos, > > PanosPlaton@HoTMaiL [mailto:[EMAIL PROTECTED]] wrote: > > > > What is wrong with the following command: > > > > SET DATE 'DD.MM.YYYY'; > > > Nothing :-) > > > I am trying to use this command into a Replication Manager > > command file on > > the purpose of uploading a dataset into a SAPDB table (the > > dates in the data > > file are in 'DD.MM.YYYY' format, whereas the date fields in > > the database are > > in 'YYYYMMDD' format). I have tried all variants I could > > imagine of (no > > quotation marks, no semicolon at the end of the line, etc.) > > and even tried > > putting it into the "DATALOAD" statement (as a field > > attribute) - to no avail! > > > > I am getting the following error (in file "repserver.log"): > > > > / E -25281: Syntax error at position 157 (Unexpected token: > > 'DD.MM.YYYY'). > > > It is indeed impossible to define free date masks with the SET DATE > command. Those can only be defined for a certain command. That means > in your special case the command would have to look like this: > > DATALOAD TABLE <table name> > <col spec> > ... > INFILE <file name> > DATE 'DD.MM.YYYY' > > > But because the format you use is the EUR format a simple solution would > be to write the SET DATE command as follows: > > SET DATE EUR > > Regards, > Steffen > -- > Steffen Schildberg > SAP DB Team > SAP Labs Berlin > _______________________________________________ > 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
