what is static sql? what is dynamic sql? Give me details
Answer Posted / sathishkumar s
Static SQL is SQL statements in an application that do not
change at runtime and, therefore, can be hard-coded into
the application.
Dynamic SQL is SQL statements that are constructed at
runtime; for example, the application may allow users to
enter their own queries. Thus, the SQL statements cannot be
hard-coded into the application.
| Is This Answer Correct ? | 11 Yes | 0 No |
Post New Answer View All Answers
What is database reorganization?
Define data page.
Define predicate?
How do I delete a column in db2?
What is host variable in db2 cobol?
What are the benefits of using the db2 database?
List out the data types available.
Mention data types used in db2 ?
Explain package in db2 and its advantages?
How can we retrieve the total number of records in RPG & CLLE?
What is the purpose of using commit?
SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected
What is node in db2?
Why select is not preferred in embedded sql programs?
What is db2 catalog database?