Page 1 of 1
DECLARE ABSORV CURSOR
Posted: Thu Mar 27, 2014 10:41 pm
by maidy
Hello Guys.
I found a statement in an online program using "DECLARE ABSORV CURSOR".
You know what "ABSORV" is?
This implies the improvement or worsening of performance?
Thanks!!
Maidy
Re: DECLARE ABSORV CURSOR
Posted: Thu Mar 27, 2014 10:44 pm
by maidy
And yet ...
OPEN ABSORV
FETCH ABSORV INTO :H
CLOSE ABSORV
Re: DECLARE ABSORV CURSOR
Posted: Thu Mar 27, 2014 11:00 pm
by Anuj Dhawan
Hi Maidy,
Unless I'm missing the obvious - "ABSORV" is cursor name, it could be just any other name. The DECLARE definition for cursor is:
Syntax
Code: Select all
>>-DECLARE--cursor-name--CURSOR--+-----------+------------------>
'-WITH HOLD-'
>--+----------------------------+--FOR--+-select-statement-+---><
| .-TO CALLER-. | '-statement-name---'
'-WITH RETURN--+-----------+-'
'-TO CLIENT-'
Re: DECLARE ABSORV CURSOR
Posted: Thu Mar 27, 2014 11:13 pm
by maidy
My god! It's true!
I was induced for a mainframe analyst, who was saying that the program was a command that he had never seen! And I thought he was right! Sorry guys ...
For me, I would delete this topic.
What a shame!
Re: DECLARE ABSORV CURSOR
Posted: Thu Mar 27, 2014 11:27 pm
by Anuj Dhawan
No problem - It just so happens once in a while...