dlangmeyer wrote:First of all - thanks for the quick reply.
Not dynamic, the cursor is ordered. What I am doing is getting the record count, then processing the cursor 1000 rows at a time.
I would like to be able to make the value a parm, so if I need to adjust the size I would just change the parm and not have to re-compile
Trying to use variable in the cursor declare, I get the following from the pre-compiler:
05 WS-MAX-COUNT PIC 9(09) VALUE ZEROES.
FETCH FIRST :WS-MAX-COUNT ROWS ONLY
DSNH104I E DSNHPARS LINE 215 COL 26 ILLEGAL SYMBOL ":".
As you will see from the explanation of the message
, you cannot select the number of rows to be fetched at run-time. You'll have to continue the way that you are.
"You have sat too long for any good you have been doing lately ... Depart, I say; and let us have done with you. In the name of God, go!" -- what I say to a junior programmer at least once a day