Page 1 of 1
Is DECLARE CURSOR executable?
Posted: Tue Jun 03, 2014 3:12 pm
by Mukul Thriphati
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?
Re: Is DECLARE CURSOR executable?
Posted: Tue Jun 03, 2014 3:33 pm
by zprogrammer
IMHO, I believe the interviewer might have checked if the DECLARE could be executed in SPUFI
Re: Is DECLARE CURSOR executable?
Posted: Tue Jun 03, 2014 5:11 pm
by Anuj Dhawan
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.
Re: Is DECLARE CURSOR executable?
Posted: Tue Jun 03, 2014 6:00 pm
by zprogrammer
access rights for the tables
IMHO,I believe this is done in BIND time