Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between static and dynamic SQL?
- 1 Answers
- 25784 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
How to execute stored procedure in db2 command editor?
What is the connection string to connect to the DB2 Database ?
What is ibm db2 database?
What is role in db2?
Is it possible to create an Instance in DB2 using DB2 Control Center ?
What is the role of data manager in the db2 database?
What is plan in cobol db2?
Discuss about db2 bind?
What is db2? Explain.
What are catalog tables in db2?
What is bind in db2?
What is access path in db2?
what is the role of the cursor in db2?
How do you concatenate the firstname and lastname from emp table to give a complete name?
What are db2 objects?
