Hi,
I've been asked if a DECLARE CURSOR executable? I was not sure about this. What does "executable" means in this context. Can someone please help?
Is DECLARE CURSOR executable?
-
Mukul Thriphati
- New Member
- Posts: 6
- Joined: Sun Feb 16, 2014 9:04 pm
-
zprogrammer
- Global Moderator
- Posts: 588
- Joined: Wed Nov 20, 2013 11:53 am
- Location: Mars
Re: Is DECLARE CURSOR executable?
IMHO, I believe the interviewer might have checked if the DECLARE could be executed in SPUFI
zprogrammer
-
Anuj Dhawan
- Founder
- Posts: 2802
- Joined: Sun Apr 21, 2013 7:40 pm
- Location: Mumbai, India
- Contact:
Re: Is DECLARE CURSOR executable?
The DECLARE CURSOR statement is declarative, not executable. In an embedded usage context, access rights for the tables etc. are checked when the cursor is opened, not when it is declared.
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.
-
zprogrammer
- Global Moderator
- Posts: 588
- Joined: Wed Nov 20, 2013 11:53 am
- Location: Mars
Re: Is DECLARE CURSOR executable?
IMHO,I believe this is done in BIND timeaccess rights for the tables
zprogrammer
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