please try to publish all code and error when executing/compiling and platform info and vrm
or see SQL0104N
Best Regards, Guy Przytula
Database Software Consultant
Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
Information Server Datastage Certified http://www.infocura.be
If you are capable of writing CLI procedures (i.e. in the 'C' language), then CLI can use array fetch techniques for rowsets.
But as stated, for LUW, at the SQL level multi-row fetch syntax via rowsets is not available yet in v9.x or v10.1.
Besides, a set based approach in SQL can yield dramatically better performance than old style row-by-row cursor based batch processing.