what is static sql? what is dynamic sql? Give me details
- 3 Answers
- 7092 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
What is sqlca’s maximum length?
What is the connection string to connect to the DB2 Database ?
What is dpf in db2?
What is meant by explain?
what is the sqlcode -501
What is database manager in db2?
What action db2 takes when a program aborts in the middle of a transaction?
Are view updateable?
How to resolve deadlock issue
What is a Foreign Key?
What is the advantage in De-normalizing tables in DB2?
How do you eliminate duplicate values in db2?
What is the max length of sqlca?
Name the lockable units in DB2?
How do I copy a table in db2?
