dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
if i have interpreted correctly:
method 1:
open file
read file, delete rows on db2 tables via 5 cursors.
close file
method 2:
open file
read file, delete rows on db2 table via cursor
close file, open file
read file, delete rows on db2 table via cursor
close file, open file
read file, delete rows on db2 table via cursor
close file, open file
read file, delete rows on db2 table via cursor
close file, open file
read file, delete rows on db2 table via cursor
close file
of the two that you have suggested, neither gives me a warm fuzzy feeling
Why the cursors?
METHOD 3:
open file
read file, delete via DELETE WHERE, on each of the 5 tables, without cursors.
close file |
|