What is dynamic SQL?



What is dynamic SQL?..

Answer / 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

More DB2 Interview Questions

How we create a tables in db2,what is the process/syntax to create a table with example plz?

2 Answers  


Explain the contention situations caused by locks?

0 Answers  


Who uses db2?

0 Answers  


What are the 4 environments which can access DB2 ?

2 Answers  


Can I use LOCK TABLE on a view?

1 Answers  






What is dbrm library?

0 Answers  


What can the SET option of the Repair Utility accomplish?

1 Answers  


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

0 Answers  


What is a db2 schema?

0 Answers  


What is normalization and what are the five normal forms?

1 Answers  


What are the three DB2 date and time data types and their associated functions?

1 Answers  


What are the various isolation levels possible?

0 Answers  


Categories