Hi ,

I am using DB2 Work Group Server Edition (Windows). I am quite new to DB2 and DB2 stored procedure. Somehow I managed to write several lines of code for the stored proc, but when the cursor holds number of rows above 100 my output shows the below and is not continuing

spDefectList - Run information has been updated.
DB2ADMIN.SPDEFECTLIST - Run started.
Data returned in result sets is limited to the first 100 rows.
Data returned in result set columns is limited to the first 20 bytes or characters.

If anyone has any view on this please help me out.


Thanks and regards,
Anoop

How about posting the stored procedure definition and which version of DB2 are you using?

Andy

are you using developer workbench for SP. It usually returns the first 100 rows. Just check there must be a option somewhere to disable it

AFAIK, there is no option to disable it ... If you want the full output, run it from a command window