Question about Delete some rows from large table - Page 2

David2002 · #16 (**permalink**) 02-14-03, 12:09

Quote:

Originally posted by chris72
If you want, you can use QMF for generating the needed delete statement in the way decripted in the last post.
You select the keys and make punctual delete statements. It avoids lock.
Remember to use commit after every delete statement!!!!!!!!!
In this way if something goes wrong rollback takes just few second (to rollback the last update!).
Is it enough clear?

Thank you all (chris72,dahalkar_p,enherber,grofaty,dollar489,... ) for spending your time in this problem.

Chris could you please explain more (we do not have MQF) do you mean I declare cursor and use "with current cursor <corsur_name> in delete command, if not give me a small sample.
Thanks again

chris72 · #17 (**permalink**) 02-17-03, 03:31

In short...you have to extract via select list all your delete statement.
Like this:
SELECT 'DELETE FROM TAB WHERE KEY_TAB=' !!KEY_TAB!!';commit;'
FROM TAB
WHERE search-condition. In this way you build all your delete statement, but these statement are row per row (I have assumed that key is the unique key!).

Of course if you have to put a more complex delete you need more than one row to write it. That is because i've mentioned QMF ....

David2002 · #18 (**permalink**) 02-17-03, 13:44

Quote:

Originally posted by chris72
In short...you have to extract via select list all your delete statement.
Like this:
SELECT 'DELETE FROM TAB WHERE KEY_TAB=' !!KEY_TAB!!';commit;'
FROM TAB
WHERE search-condition. In this way you build all your delete statement, but these statement are row per row (I have assumed that key is the unique key!).

Of course if you have to put a more complex delete you need more than one row to write it. That is because i've mentioned QMF ....

Thank you so much chris.

Internet Services

Web Development

Digital Marketing

Consumer Tech