What is the difference between static and dynamic SQL?
- 1 Answers
- 25346 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 types of copies can be made with the COPY Utility ?
What is package in cobol db2?
Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?
What is a db2 package?
List out the three types of page locks that can be held.
How to get Top 10 Salaries from a Table
What types of tables are there in the db2 database?
Explain the function of data manager.
What are the three DB2 date and time data types and their associated functions?
Q4. How will you get the count of record without using COUNT verb in query?
What are the contents of dclgen?
what is difference between Plan and Package
COBOL 
