Hi Martin,
[Martin Pawlack wrote]
> Subject: Replication Manager (repmcli) and DATE (datetimeformat)
>
> Hi,
>
> i am trying to to fill a table with the repmcli from a data file with
> the data file format COMPRESSED.
> I have problems with the DATE imports, the datetimeformat in the data
> file is EUR ('DD.MM.YYYY').
>
>
> If i use this command file
> ----------------------------------------
> DATALOAD TABLE presse1
> datum_der_eingabe 6
> INFILE 'pressedatenbank.data' COMPRESSED
> ----------------------------------------
> repmcli reports : Invalid input for date or time column: 28.12.2001
>
>
> If i use this command file
> ----------------------------------------
> DATALOAD TABLE presse1
> datum_der_eingabe 6 DATE
> INFILE 'pressedatenbank.data' COMPRESSED
> ----------------------------------------
> repmcli reports : File option FORMATTED required.
>
> How can i change the datetimeformat and using the data file format
> COMPRESSED?
>
You simply specify the date format in the command.
It would look like your first command with on additional
specification:
DATALOAD TABLE presse1
datum_der_eingabe 6
INFILE 'pressedatenbank.data' COMPRESSED
DATE EUR
The second command you tried fails because you cannot assign a
position and a function at once to a column. And the command
wouldn't have done what you wanted. The command
DATALOAD TABLE presse1
datum_der_eingabe DATE
INFILE 'pressedatenbank.data' COMPRESSED
would assign the date when you process the command to column
datum_der_eingabe in every single record.
HTH.
Regards,
Steffen
--
Steffen Schildberg
SAP DB Team
SAP Labs Berlin
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
