DECLARE ABSORV CURSOR

RDBMS from IBM and IBM's Hierarchical DBMS and Transaction Manager (IMS DC).
Post Reply
maidy
Registered Member
Posts: 11
Joined: Fri Feb 21, 2014 11:57 pm

DECLARE ABSORV CURSOR

Post 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
maidy
Registered Member
Posts: 11
Joined: Fri Feb 21, 2014 11:57 pm

Re: DECLARE ABSORV CURSOR

Post by maidy »

And yet ...
OPEN ABSORV
FETCH ABSORV INTO :H
CLOSE ABSORV
User avatar
Anuj Dhawan
Founder
Posts: 2799
Joined: Sun Apr 21, 2013 7:40 pm
Location: Mumbai, India
Contact:
India

Re: DECLARE ABSORV CURSOR

Post 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-'
Thanks,
Anuj

Disclaimer: My comments on this website are my own and do not represent the opinions or suggestions of any other person or business entity, in any way.
maidy
Registered Member
Posts: 11
Joined: Fri Feb 21, 2014 11:57 pm

Re: DECLARE ABSORV CURSOR

Post 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!
User avatar
Anuj Dhawan
Founder
Posts: 2799
Joined: Sun Apr 21, 2013 7:40 pm
Location: Mumbai, India
Contact:
India

Re: DECLARE ABSORV CURSOR

Post by Anuj Dhawan »

No problem - It just so happens once in a while... :)
Thanks,
Anuj

Disclaimer: My comments on this website are my own and do not represent the opinions or suggestions of any other person or business entity, in any way.
Post Reply

Create an account or sign in to join the discussion

You need to be a member in order to post a reply

Create an account

Not a member? register to join our community
Members can start their own topics & subscribe to topics
It’s free and only takes a minute

Register

Sign in

Return to “IBM DB2 and IMS DB/DC”