"Al Murry" <am****@northtech.net> wrote in message
news:pa****************************@northtech.net. ..
Using 6.1, Copying data in one large table to another using sql
and do not know how to issue a commit. (say every 5000 records)
to keep the log files from filling up.
I can find no informations on this...
db2load is not practical here.
Are you sure you can't do an export (with an SQL statement you provide) and
then an import to insert the rows with a commit interval?
If not, you will need to open a select cursor in your program WITH HOLD
option (keeps cursor open even after a commit), fetch the row one at a time,
then insert into other table for each row fetched, then commit at the
desired interval.