Hi All,
I am aware that i can retrieve the number of rows i need by using the "fetch first N rows" statement.
Can anyone suggest a way to retrieve "N" number of rows where "N" is dynamic.
I am passing in the "N" value as a parameter to the SP.
Any other suggestions to achieve this is also appreciated. I m using DB2 version 8.
Rgds.
L.Karu
I am aware that i can retrieve the number of rows i need by using the "fetch first N rows" statement.
Can anyone suggest a way to retrieve "N" number of rows where "N" is dynamic.
I am passing in the "N" value as a parameter to the SP.
Any other suggestions to achieve this is also appreciated. I m using DB2 version 8.
Rgds.
L.Karu