GlacierWhat is wrong with the following command: SET DATE 'DD.MM.YYYY';
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'). I am attaching the command file. My data file is tab-delimited, no characters around text field values. I am using SAPDB, Rel.7.3. TIA, Panos Platon Tsapralis, SAP-R/3 Specialist, ABAP/4 Developer, Athens, GREECE, cell phone: +306936353566, telefax: +18019925665, [EMAIL PROTECTED], [EMAIL PROTECTED]
BEGIN:VCARD VERSION:2.1 N:Tsapralis;Panos;Platon FN:Panos Platon Tsapralis NICKNAME:Tsapralis ORG:Private@Home TEL;WORK;VOICE:+302108066619 TEL;HOME;VOICE:+302108066618 TEL;CELL;VOICE:+306936353566 TEL;WORK;FAX:+448714332460 TEL;HOME;FAX:+18019925665 ADR;WORK:;;;Athens;Maroussi, Attica;15126;GREECE LABEL;WORK;ENCODING=QUOTED-PRINTABLE:Athens, Maroussi, Attica 15126=0D=0AGREECE ADR;HOME:;;;Athens;Attica;15126;GREECE LABEL;HOME;ENCODING=QUOTED-PRINTABLE:Athens, Attica 15126=0D=0AGREECE X-WAB-GENDER:2 BDAY:19620706 EMAIL;INTERNET:[EMAIL PROTECTED] EMAIL;PREF;INTERNET:[EMAIL PROTECTED] EMAIL;INTERNET:[EMAIL PROTECTED] EMAIL;INTERNET:[EMAIL PROTECTED] EMAIL;INTERNET:[EMAIL PROTECTED] EMAIL;INTERNET:[EMAIL PROTECTED] EMAIL;INTERNET:[EMAIL PROTECTED] EMAIL;INTERNET:[EMAIL PROTECTED] EMAIL;INTERNET:[EMAIL PROTECTED] EMAIL;INTERNET:[EMAIL PROTECTED] EMAIL;INTERNET:[EMAIL PROTECTED] EMAIL;INTERNET:[EMAIL PROTECTED] REV:20030217T190146Z END:VCARD
/ Load data from external ASCII text data file "eban_tab.txt" / into SAP-R/3 application table "(Z)EBAN". VERSION / AUTOCOMMIT ON / SET DECIMAL '/./,/'; / SET COMPRESSED '/ //'; / / SET DATE 'DD.MM.YYYY'; / DATALOAD TABLE ZEBAN REJECT DUPLICATES MANDT 2 BSTYP 3 BANFN 4 BNFPO 5 EBELN 6 EBELP 7 BSART 8 LOEKZ 9 STATU 10 FRGKZ 11 EKGRP 12 ERDAT 13 AFNAM 14 TXZ01 15 MATNR 16 WERKS 17 BEDNR 18 MATKL 19 MENGE 20 DECIMAL (3) MEINS 21 BADAT 22 LPEIN 23 PREIS 24 DECIMAL (2) PEINH 25 DECIMAL (0) BEDAT 26 WAERS 27 SPRAS 28 INFILE 'C:\Documents and Settings\Panos\My Documents\workfile\development\SAP\CERES\SampleData\Ver#001\eban_tab.txt' / / ERDAT 13 DATE 'DD.MM.YYYY' / BADAT 22 DATE 'DD.MM.YYYY' / BEDAT 26 DATE 'DD.MM.YYYY'
