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
