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
DECLARE ABSORV CURSOR
- Anuj Dhawan
- Founder
- Posts: 2803
- Joined: Sun Apr 21, 2013 7:40 pm
- Location: Mumbai, India
- Contact:
Re: DECLARE ABSORV CURSOR
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
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.
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.
Re: DECLARE ABSORV CURSOR
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!
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
- Founder
- Posts: 2803
- Joined: Sun Apr 21, 2013 7:40 pm
- Location: Mumbai, India
- Contact:
Re: DECLARE ABSORV CURSOR
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.
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.
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