What is dynamic SQL?

Answer Posted / s

Dynamic SQL are built at execution time. Dynamic SQL does
not go through the program preparation process like static
SQL and can execute different SQL statements in one
program.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Mention the downsides of page level lock.

909


Why cursor is used in db2?

756


How do you simulate the explain of an embedded sql statement in spufi/qmf?

827


When the like statement is used?

873


What is load utility in db2?

872


What is dbrm? What it contains? When it will be created?

793


What does db2 plan contain?

748


How do you pull up a query which was previously saved in qmf?

890


How to view db2 table structure?

782


SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected

11354


What is a db2 cursor?

795


On which levels locks can be applied?

849


Why do we bind in db2?

855


What is dbrm in db2 database?

782


How to compare data between two tables in db2?

834