Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

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

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Mainframe Interview Questions
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    Post subject: Diff between select in QMF/SPUFI and select in embeded SQL
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    Post subject:
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    Post subject: Reply to: Diff between select in QMF/SPUFI and select in emb
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: 1187
Location: Bangalore,India

PostPosted: Tue Apr 06, 2010 1:03 pm    Post subject:
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    Post subject: Reply to: Diff between select in QMF/SPUFI and select in emb
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    Post subject:
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    Post subject: Reply to: Diff between select in QMF/SPUFI and select in emb
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

Site Director


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

PostPosted: Mon Jul 19, 2010 12:37 pm    Post subject:
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    IBMMAINFRAMES.com Support Forums -> Mainframe Interview Questions All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts SQL - select data available in index Nileshkul DB2 3 Mon Jun 26, 2017 1:30 am
No new posts SPUFI -- Joining 3 tables – data in... Sysaron DB2 2 Wed Mar 08, 2017 4:18 am
No new posts Two Selects in a single select query Rohit Umarjikar DB2 1 Fri Nov 04, 2016 8:46 pm
No new posts Select first 2 group data vice_versa DFSORT/ICETOOL 10 Mon Jun 13, 2016 2:21 pm
No new posts Problems in File-Aid / DB2 Spufi whil... amitc23 CLIST & REXX 6 Fri Feb 12, 2016 1:59 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us