dbload insert, update, delete
christrier wanted to apply three difference files (new, deleted and updated rows) to another database and knew only how to insert the new rows with dbload. Christian Knappke's replies were mostly empty or unreadable, but a suggestion apparently to run deletes through dbaccess was made; the poster worried about speed for around 100,000 lines. No clear solution given.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Hi!
My problem is: I have a database and I am extracting some data from it
and after extracting I am writing the "differences" between two files
in other files, where one files contains all new rows, one file
contains all deleted rows and one file contains all updated rows.
Now I have to insert these three files into another DB.
I can insert the "new"-File into the database with dbload but at the
moment I have no clue about how to "insert" the updates and the
deletes.
If someone gave me a hint, that would be great
Greetings
Chris
\
this would be a possibility! the problem is that i don't know how large
this "difference"-files will be and I have no idea how fast dbaccess
deletes, say 100.000 lines.
i will try your option
greetings
chris
[quoting added and repaired]
>
> In that case you should also include COMMITs every few 1000 lines
> to avoid long transaction aborted issues.
>
> And it's not dbaccess that deletes the rows but the server.
> dbaccess justs sends the SQL statements.
thank you for your advice although it is clear to me that dbaccess does
not delete any rows, but to explain something it is easier to say "is
it fast?" instead of "blablub how fast are the sqls processed by the
server".
greetings
chris