View previous topic :: View next topic
|
Author |
Message |
bnveena
New User
Joined: 29 May 2007 Posts: 50 Location: hyderabad
|
|
|
|
Can any one tell me the difference in select in QMF/SPUFI and select in embeded SQL??? |
|
Back to top |
|
|
Escapa
Senior Member
Joined: 16 Feb 2007 Posts: 1399 Location: IL, USA
|
|
|
|
Host variables? |
|
Back to top |
|
|
bnveena
New User
Joined: 29 May 2007 Posts: 50 Location: hyderabad
|
|
|
|
Not about the host variables. This was an interview question asked like wht is the difference in giving the select statement giving in QMF and a select statement giving inside the program |
|
Back to top |
|
|
guptae
Moderator
Joined: 14 Oct 2005 Posts: 1208 Location: Bangalore,India
|
|
|
|
Hello veena,
I believe difference is in the time which BIND occurs. In embedded sql
BIND is done prior to execution time & stored in PLAN but for QMF/SPUFI
BIND occurs at execution time |
|
Back to top |
|
|
bnveena
New User
Joined: 29 May 2007 Posts: 50 Location: hyderabad
|
|
|
|
thank you.. |
|
Back to top |
|
|
GuyC
Senior Member
Joined: 11 Aug 2009 Posts: 1281 Location: Belgium
|
|
|
|
it's called static and dynamic sql and means what guptae described |
|
Back to top |
|
|
sambit_mech
New User
Joined: 14 Jul 2010 Posts: 13 Location: India
|
|
|
|
At the time of bind, in the bind card if you use VALIDATE(RUN) instead of VALIDATE(BIND), authority check will be done at run-time, not at bind time. So guptae's answer is not correct. However, normally bind cards contain VALIDATE(BIND).
Coming to the answer to the question, QMF/SPUFI is online execution, whereas for embedded SQL I/O processing is involved for transferring from COBOL to DB2. |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
Quote: |
So guptae's answer is not correct. |
Yes, it is - as well as the followup from GuyC.
Quote: |
QMF/SPUFI is online execution, whereas for embedded SQL I/O processing is involved for transferring from COBOL to DB2. |
Completely mis-leading. . . And whatever does the last bit mean?
Quote: |
At the time of bind, in the bind card if you use VALIDATE(RUN) instead of VALIDATE(BIND), authority check will be done at run-time, not at bind time. |
Which basically has nothing to do with the original question. . . |
|
Back to top |
|
|
|