HI

We are having a stored proc which uses a cursor to return the records of a table. The table contains 3.5 Million records.

Can I know what is the maximum possible records we can return from a cursor..?

Regards
Abhiram

The number of rows is limited by your storage and underlying tables. The manual says you can have 128 *10^10 rows per database partition in a non-partitioned table and the same number of rows in a table partition of a partitioned table per database partition. If you do cross joins, I guess your limiting factors will not be DB2 but rather storage and the speed with which your application can process the rows.

p.s: 3.5 million rows is not a lot and I wouldn't start to worry about it.

i dont think there is a limit on the number of records but rather see your dba as they are the one who can help u in this regard as they are the pain creaters and pain killers