KyaPoocha.com

Huge Collection of Interview Questions

Search our list of 7708 Interview Questions


How do you simulate the EXPLAIN of an embedded SQL statement in SPUFI/QMF ? Give an example with a host variable 

Posted in Database Interview Questions

Use a question mark in place of a host variable (or an unknown value). For instance,
SELECT EMP_NAME FROM EMP WHERE EMP_SALARY > ?

Post Your Answer!
Send This to a Friend

← How do you do the EXPLAIN of a dynamic SQL statement ?
What are the isolation levels possible ? →

If you liked this question/asnwer, make sure you
Subscribe to KyaPoocha.com RSS feed!


BOOKMARK THIS : BlinkList | del.icio.us | Digg it | Furl | reddit | StumbleUpon | Yahoo MyWeb |

Related Interview Questions

  • What is meant by embedded SQL ?  25.07.08

    They are SQL statements that are embedded with in application program and are prepared during the program preparation process before the program is executed. Af...

  • Explain the EXPLAIN statement ?  14.07.08

    The explain statement provides information about the optimizer's choice of access path of the SQL....

  • What are ORACLE PRECOMPILERS?  11.05.08

    Using ORACLE PRECOMPILERS ,SQL statements and PL/SQL blocks can be contained inside 3GL programs written in C,C++,COBOL,PASCAL, FORTRAN,PL/1 AND ADA. The Prec...

  • What is the purpose of the WHENEVER statement ?  03.04.08

    The WHENEVER statement is coded once in the host program to control program actions depending on the SQL-CODE returned by each sql statement within the program....

  • Can we declare DB2 HOST variable in COBOL COPY book ?  24.03.08

    NO. If we declare DB2 host variable in COBOL COPY book, at the time of Pre-compilation we get the host variable not defined, because pre-compiler will not expan...

  • How do you do the EXPLAIN of a dynamic SQL statement ?  13.03.08

    There are two methods to achieve this: 1. Use SPUFI or QMF to EXPLAIN the dynamic SQL statement 2. Include EXPLAIN command in the embedded dynamic SQL stateme...

  • What is EXPLAIN?  13.03.08

    EXPLAIN is used to display the access path as determined by the optimizer for a SQL statement.  It can be used in SPUFI (for single SQL statement) or in BIND s...

  • What are the contents of a DCLGEN ?  12.03.08

    EXEC SQL DECLARE TABLE statement which gives the layout of the table/view in terms of DB2 datatypes.A host language copy book that gives the host variable defin...

  • What is a host variable ?  09.03.08

    This is a data item that is used in an SQL statement to receive a value or to supply a value. It must be preceded by a colon (:) to tell DB2 that the variable i...

  • What are ORACLE PRECOMPILERS ?  16.03.06

    Using ORACLE PRECOMPILERS ,SQL statements and PL/SQL blocks can be contained inside 3GL programs written in C,C++,COBOL,PASCAL, FORTRAN,PL/1 AND ADA. The Prec...