IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Diff between select in QMF/SPUFI and select in embeded SQL


IBM Mainframe Forums -> Mainframe Interview Questions
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
bnveena

New User


Joined: 29 May 2007
Posts: 50
Location: hyderabad

PostPosted: Tue Apr 06, 2010 10:41 am
Reply with quote

Can any one tell me the difference in select in QMF/SPUFI and select in embeded SQL???
Back to top
View user's profile Send private message
Escapa

Senior Member


Joined: 16 Feb 2007
Posts: 1399
Location: IL, USA

PostPosted: Tue Apr 06, 2010 12:57 pm
Reply with quote

Host variables?
Back to top
View user's profile Send private message
bnveena

New User


Joined: 29 May 2007
Posts: 50
Location: hyderabad

PostPosted: Tue Apr 06, 2010 1:02 pm
Reply with quote

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
View user's profile Send private message
guptae

Moderator


Joined: 14 Oct 2005
Posts: 1208
Location: Bangalore,India

PostPosted: Tue Apr 06, 2010 1:03 pm
Reply with quote

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
View user's profile Send private message
bnveena

New User


Joined: 29 May 2007
Posts: 50
Location: hyderabad

PostPosted: Tue Apr 06, 2010 1:16 pm
Reply with quote

thank you..
Back to top
View user's profile Send private message
GuyC

Senior Member


Joined: 11 Aug 2009
Posts: 1281
Location: Belgium

PostPosted: Mon May 17, 2010 6:32 pm
Reply with quote

it's called static and dynamic sql and means what guptae described
Back to top
View user's profile Send private message
sambit_mech

New User


Joined: 14 Jul 2010
Posts: 13
Location: India

PostPosted: Mon Jul 19, 2010 11:30 am
Reply with 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. 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
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Mon Jul 19, 2010 12:37 pm
Reply with quote

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> Mainframe Interview Questions

 


Similar Topics
Topic Forum Replies
No new posts DELETE SPUFI DB2 1
No new posts Adding QMF and SPUFI to the ISPF menu DB2 20
No new posts Dynamically pass table name to a sele... DB2 2
No new posts SELECT from data change table DB2 5
No new posts Select two different counts from SQL... DB2 6
Search our Forums:

Back to Top