What is the difference between static and dynamic SQL?
- 1 Answers
- 25401 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
What is the role of schema in the db2 database?
How can you find out the # of rows updated after an update statement?
How to take backup of table in db2?
How do you simulate the explain of an embedded sql statement in spufi/qmf?
What is a dbrm in db2?
What is the use of dclgen in db2?
What is a trigger in the db2 database?
How to find the maximum value in a column in the db2 database?
What is db2 stogroup?
What is meant by dclgen?
What is cursor in dbms?
How can we retrieve the total number of records in RPG & CLLE?
What is the physical storage length of the data types: date, time, timestamp in the db2 database?
in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?
what is db2 restart?
