I'm using iSeries v5r4.

I have a proc:

SELECT *
FROM TABLE
FETCH FIRST @PARAM ROWS ONLY

But that does not work.

I've tried

SELECT *
FROM TABLE
FETCH FIRST || @PARAM || ROWS ONLY

Which doesn't work either. Anyone had success with this? I'd prefer not to use ROW_NUMBER ( ) OVER ( ) if possible.

Thanks

1. Host variable @PARAM has to be declared as integer
2. Also, in procedure, you can create the dynamic query and execute later from cursor

Lenny

1. It is!
2. Could you give an example please?

Thanks!

You have an example. This is your procedure. Any additional information in manuals:

http://publib.boulder.ibm.com/epubs/pdf/dsnsqj15.pdf