what is static sql? what is dynamic sql? Give me details
Answer Posted / yuvaevergreen
>>static sql is hard coded in the cobol program. The static
sql is syntax checked,separately processed and executable
format of the sql is made ready by the precompiler even the
before the cobol program is compiled.
>>dynamic sql,though precompiled like static sql but they
are prepared and executed at run time. sql is of string
format and executed by SQL PREPARE or EXECUTE IMMEDIATE
statement.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What are the bind parameters ibm db2?
What is cursor stability in db2?
What is cursor with hold option in db2?
Explain about mirror activator disk mirroring?
How to check table size in db2 sap?
Mention the different locking levels that are available in db2.
How do I add a column to a table in db2?
What is database reorganization?
What is deadlock in db2?
What are the various data types available in db2?
What is the syntax for creating a table in the db2 database?
What is runstats utility in db2?
What does db2 stand for?
What does sqlcabc has?
Mention data types used in db2 ?