var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Paramertize Fetch First n Rows Only
I'm using iSeries v5r4.
I have a proc:
FETCH FIRST @PARAM ROWS ONLY
But that does not work.
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.
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
1. It is!
Originally Posted by Lenny77
2. Could you give an example please?
You have an example. This is your procedure. Any additional information in manuals:
Originally Posted by snowcl16