Paramertize Fetch First n Rows Only in DB2

Question

I'm trying to do the following:

  select * 
  from table      
  fetch first @param rows only

@param is an int.

DB2 would not have it. I've heard of concatenating it with ||, but I can't seem to get that to work.

Anyone have experience with this?

(PS I saw a similar question (http://stackoverflow.com/questions/2621420/db2-wont-allow-parameterize-fetch-first-x-rows-only) but didn't understand his approach using ':1'.

Answer 1

You could try the following:

select t.*
from (select r.*, row_number() over() as row_num  
      from table r) as t
where row_num <= @param