Interested to Buy Any Domain ? << Click Here >> for more details...
what is static sql? what is dynamic sql? Give me details
- 3 Answers
- 8328 Views
- I also Faced
- E-Mail Answers
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
Give a brief description of db2 isolation levels?
What is query_cache_limit?
Why do we bind in db2?
What is the physical storage length of date data type?
How many databases are there?
How can tablespace be moved to another dasd volume that is allocated for that tablespace?
In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?
Explain the function done by data manager?
What does db2 mean?
How to check table size in db2 sap?
What are the rules for db2 programming?
Which are the db2 tools to protect integrity of the database?
How to view db2 table structure?
What is difference between isnull and coalesce?
Highlight all the advantages that are attached to a package.
