Originally Posted by db2maf
My system: DB2 v9.5_FP0 (Wintel).
This is not a problem.
Actually, that may be a problem (running Fix-pack 0). Go to the DB2 fix-pack download site and get the latest fix pack for version 9.5.
You don't "need" to declare a cursor, you just create a script using export and import, or invoke these commands using a DB2 Admin Stored Procedure (you will have to look up the specs on that).
export to EMPLOYEE.DEL of DEL select * from EMPLOYEE
load from EMPLOYEE.DEL of DEL insert into EMPLOYEE nonrecoverable
Use nonrecoverable to avoid logging and to avoid taking a backup after the load. You may have to do a "set integrity" on the table after the load.
There are many options on the Load command, and also you can use import command (which is similar but slower).