Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between static and dynamic SQL?
- 1 Answers
- 25789 Views
- I also Faced
- E-Mail Answers
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 |
What is innodb buffer pool?
Is db2 a mainframe database?
Differentiate between cs and rr isolation levels? Where do you specify them?
Is there any advantage to denormalizing DB2 tables?
Which isolation level provides highest data integrity?
How can i install db2 9.x on AIX based system..? plz reply the detailed steps involved....?
How many databases are there?
What is the use of DELGEN in DB2? Can we Write the program with out using it?
What is the max length of sqlca?
How to create backup table in db2?
Can one database have multiple instances?
my project is insurance management system,how to explain my work environment in interview?
COBOL 
