What is the difference between static and dynamic SQL?

Question Posted / guest

1 Answers
25883 Views
I also Faced
E-Mail Answers

What is the difference between static and dynamic SQL?..

Answer / jkb

In Stats SQL, the statement is prepared before the program
is executed and the operational form of the statement
persists beyond the execution of the program. A source
program containing static SQL statements must be processed
by an SQL precompiler before it is compiled. The
precompiler checks the syntax of the SQL statements, turns
them into host language comments, and generates host
language statements to invoke DB2.

A dynamic SQL statement is prepared during the execution of
an SQL application, and the operational form of the
statement is not persistent. The source form of the
statement is a character string passed to DB2 by an
application program using the static SQL statement PREPARE
or EXECUTE IMMEDIATE.

Is This Answer Correct ?

52 Yes

9 No

Post New Answer

More DB2 Interview Questions

What is db2 command?

0 Answers

I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?

3 Answers

How to resolve -502 sql code in DB2?

2 Answers Cap Gemini,

4. A DB2 application is bound with uncommitted Read isolation level.It issues a request that retrieves 20 rows out of 200000 in the table. Which of the following descrbes the rows that are locked as a result of this request? a. None of the rows are locked. B.The retrieved rows are locked. C.The last row of the result set is locked. D.The rows not previously updated by another application are locked.

3 Answers Wipro,

Define declaration generator (dclgen).

0 Answers

what is rebinding ?

1 Answers IBM,

What is bind plan?

0 Answers

what is Runstats? Whem will u choose to runatats?

1 Answers Danske,

1) I have 3 programs : PGMA, PGMB, PGMC. PGMA calls PGMB and PGMB calls PGMC. I have to do inserts, updates in all the 3 pgms. 2) Say PGMC has done its work successfully and returned to PGMB 3) PGMB had an SQL error while doing some update 4) PGMA has already done some updates before calling PGMB all are running under the same CICS region. What will happen if I issue SYNCPOINT ROLLBACK in PGMB when it abends ? Does all the changes in PGMA,B,C rollback ? (because all the pgms belong to same task).

1 Answers

Explain dclgen.

0 Answers

How to find last record before record through SQLRPGLE?

1 Answers IBM,

What is filter factor?

2 Answers

For more DB2 Interview Questions Click Here