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

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???

Escapa · Posted: Tue Apr 06, 2010 12:57 pm

Host variables?

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

guptae · Posted: Tue Apr 06, 2010 1:03 pm

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

bnveena · New User Joined: 29 May 2007 Posts: 50 Location: hyderabad

thank you..

GuyC · Posted: Mon May 17, 2010 6:32 pm

it's called static and dynamic sql and means what guptae described

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.

dick scherrer · Posted: Mon Jul 19, 2010 12:37 pm

Hello,