DECLARE ABSORV CURSOR

[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

[maidy]

And yet ...
OPEN ABSORV
FETCH ABSORV INTO :H
CLOSE ABSORV

[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-'

[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!

[Anuj Dhawan]

No problem - It just so happens once in a while...