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

What are the various locks available?

5 Answers   CTS,


How to create db2 table in mainframe?

0 Answers  


How can you split a table in to exactly half?

7 Answers   HSBC,


What is the role of the data page in the db2 database?

0 Answers  


What information is held in SYSIBM.SYSCOPY?

1 Answers  






pls explain the precompilation process of cobol-db2 pgm

3 Answers   HCL, IBM,


Is db2 free?

0 Answers  


i have a table like this : Name ADDRESS Toto 123 ... Toto 456 ToTo 678 I would like to delete 2 last row...please tell me how to delete its

5 Answers   EDS,


What do you do to keep the cursor from closing after a commit?

1 Answers  


What is the maximum size of a char data type in db2?

0 Answers  


What is sqlca’s maximum length?

0 Answers  


before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?

0 Answers   IBM,


Categories