Hello!
Replication server version: 7.3.0
Repmcli version: 7.3.0
Server 7.3.0.18
OS: W2K SP2.
I'm trying to insert values from a CSV-file
into a table which contains an ID column
as primary key.
This ID column is filled - normally - by the
application that fetches a value from a existing
sequence for it. It's not DEFAULT SERIAL because
the application needs the ID value before inserting
rows.
I now tried to insert values using the repmcli with
this definition:
DATALOAD TABLE tbl_kunden
id SEQNO 1 1
knr 1
name1 2
name2 3
anschrift 4
plz 5
ort 6
telnr 8
faxnr 9
INFILE 'kunden.csv' COMPRESSED
SEPARATOR ';' DELIMITER ''
and get:
Replication server error (-4 : 'ðConnection broken')
Unfortunately the repserver.log contains only the start
command and ends without further output. I presume the
repserver crashed.
If i doesn't include the SEQNO line, it starts but complains
about missing NON-NULL values - that's ok :).
I'll try importing the values using a temporary tabel without
the ID and do a INSERT ... SELECT then.
But: What's wrong with SEQNO?
Is there any possibility to teach repserver about the existing
sequence to grab numbers from?
Best Regards,
Peter
--
[EMAIL PROTECTED]
