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
How to find the maximum value in a column in the db2 database?
What does db2 blu stand for?
What is difference between isnull and coalesce?
Mention the different locking levels that are available in db2.
What is scrollable cursor in db2?
What is the information associated with sysibm.syslinks table?
Explain about rct.
How to test SQL -911 error while developing COB-DB2 program
List some fields from sqlca?
What are host variables in db2?
What is cursor with hold option in db2?
What is dbrm? When it will be created?
What is netezza database?
What are types of indexes?
I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?