What is dynamic SQL?

DB2 ( IBM Database 2 ) Interview Questions

(Continued from previous question...)

What is dynamic SQL?

DynamicvSQL is a SQL statement created at program execution time.

(Continued on next question...)

Other Interview Questions

• How could one combine a set of incremental image copies into a single copy?
• What is SQLcode - 922?
• What is the difference between CS and RR isolation levels ?
• What is lock contention?
• What will the FREE command do to a plan?
• How do you declare a host variable ...
• What does the CHECK Utility do?
• What is the equivalent COBOL DATA Type for Decimal(x,y) in DB2 ?
• What is the SQL Communications Area and what are some of its key fields?
• What is filter factor?
• More...