Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between static and dynamic SQL?
- 1 Answers
- 25803 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 the cursor in db2?
What do you mean by commit and rollback?
What is the difference between cursor stability and repeatable read isolation levels?
What is sqlca?
Highlight all the advantages that are attached to a package.
What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?
What is dbrm library?
What is a db2 collection?
What is null in db2?
What is db2 connect?
Mention a credible reason why select* is never given preference in an sql program that has been embedded.
How can the duplicate values be eliminated from db2 select?
Outputs of explain are with matchcols = 0. What does this signify?
Explain the function done by data manager?
How can we read records for specific member in CL? AND rpg?
