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 coalesce in db2?
What is precompiler in db2?
What is cobol db2?
What is dbrm in db2 database?
Can there be more than one cursor open for any program?
What are the various isolation levels possible?
How do you eliminate duplicate values in db2?
can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well
Explain about open switch business continuity software?
What is access path in db2?
How and when does the db2 enforces the unique key?
What does db2 stand for?
What is db2 plan table?
When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?
What is collection in db2 bind?