Hi,
i am using Version: 7.3.0 of repmcli, it has problems with empty Strings
(for example ""), so i changed every "" in " " in the data file and
appended NULL ' ' to the command file. But now repmcli reports: Invalid
input for date or time column:
I have attached the command file and the data file.
---------------------------------------------------------------
repmcli -u xxx,xxx -d xxx -b command1.dat
Opened connection to REPLICATION SERVER at node local host.
REPLICATION SERVER Log File:
'/var/opt/sapdb/indep_data/wrk/repserver.log'
User vpressedb connected to database TNG1 on local host.
DATALOAD TABLE presse1
id 1
anrede 2
datum_der_eingabe 6
datum_der_aenderung 7
dfue 8
durchwahl 9
eingabe_von 10
fax 11
fax_priv 12
firma 13
kategorie 14
land 16
telefon_mobil 18
nachname 19
notizen 20
ort 21
plz 24
plz_priv 25
strasse 26
strasse_priv 27
telefon_firma 28
telefon_priv 29
taetigkeitsfeld 30
vorname 31
mobiltelefon_kopie 33
email 34
www_adresse 35
INFILE '/var/tng/tmp-transfer/pressedatenbank/test.data' compressed
NULL ' '
DATE EUR
Error during execution
-->-25301
Invalid input for date or time column:
Defined maximum number of errors (1) reached
1 error(s) during execution of command file 'command1.dat'.
---> See log file(s) for more information.
Some error(s) occurred running command.
---> See log file(s) for more information.
---------------------------------------------------------------
greetings,
Martin
Schildberg, Steffen wrote:
> 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
>
1,"Herr","Herr Schmidt","^K","Sehr geehrter Herr Schmidt,"," ","28.12.2001"," "," ","
","4318810088"," ","dpa
Kiel","Institut/MaFo","1_PV_Schleswig-Holstein^K","D","2_PV_ESSH_Einladung_Pressekonf^K3_PV_ESSH_Kampagnenstart_SHPresse^K15_PV_ESSH_StartReminderkampagne^K","
","Schmidt","Weihnachten 96^Kxx^KTelefonat mit Frau Baumann (5.7.2000)^K^KDagmar
Hansen-Kohlmorgen^K^Kvorab ^Knachher","Kiel","D-24105 Kiel"," ","24105","
","Esmarchstr. 24"," ","431881000"," ","Presseagentur"," ","Sehr geehrter Herr
Schmidt,"," "," "," ","Sehr geehrter Herr Schmidt,","^K"
DATALOAD TABLE presse1
id 1
anrede 2
datum_der_eingabe 6
datum_der_aenderung 7
dfue 8
durchwahl 9
eingabe_von 10
fax 11
fax_priv 12
firma 13
kategorie 14
land 16
telefon_mobil 18
nachname 19
notizen 20
ort 21
plz 24
plz_priv 25
strasse 26
strasse_priv 27
telefon_firma 28
telefon_priv 29
taetigkeitsfeld 30
vorname 31
mobiltelefon_kopie 33
email 34
www_adresse 35
INFILE '/var/tng/tmp-transfer/pressedatenbank/test.data' compressed
NULL ' '
DATE EUR
