what is static sql? what is dynamic sql? Give me details

Answer Posted / ankitha

static and dynamic sql are the sql statements which are
coded in pgms . in static the execution of sql is known
means which sql statement should execute after any sql
statements but in dynaamic the execution of any sql
statements will happens in run time .it is like chioce

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do you select a row using indexes in db2?

742


Explain about dbrm.

684


What is the difference between plan and package in db2?

689


What is sqlca?

702


How is deadlock resolved?

743






How can you classify the locks in db2?

721


What does db2 mean?

663


Explain in detail about buffer manager and its functionalities?

661


What is buffer pool in the db2 database?

719


In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?

725


What is the function of logging in the db2 database?

730


What are the prerogatives?

701


What kind of database is db2?

662


What is check constraint in db2?

706


What is page size in db2?

638