Interested to Buy Any Domain ? << Click Here >> for more details...
what is static sql? what is dynamic sql? Give me details
- 3 Answers
- 7991 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
Which are the db2 tools to protect integrity of the database?
How do I add a column to an existing table in db2?
How can you do the explain of a dynamic sql statement?
How to fetch the last row from the table in SQL (db2)?
What is db2 plan table?
What is a db2 package?
What is image copy in db2?
What is the syntax for FETCH in DB2 ?
Mention the various locks that are available in db2.
List down the data types in the db2 database.
What is database alias db2?
What is phantom read in db2?
What is dbrm in db2 database?
Is schema the same as database?
What is the physical storage length of time data type?
