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

My cobol program(not having any sql statements) is calling another cobol program ( having sql statements), what is needed for compilation and run in jcls .

3 Answers   Cap Gemini, RBS,


My sql statement select avg(salary) from emp yields inaccurate results. Why?

0 Answers  


quary for 1> fetch last record 2> fetch in reverse order 3> fetch last 5 row 4> fetch second last record (their is no primary key) i think concept of count can be use for this in 4th

5 Answers  


what is main use of table space and index object? please its urgent

5 Answers   CA, Cap Gemini, CGI, CTS, EDS, HTC, IBM, Satyam, Syntel, TCS, Wipro,


What is cobol db2?

0 Answers  






what is utility for parm lib

0 Answers   IBM,


How to resolve -805 error in DB2?

1 Answers   Cap Gemini,


Can you access the DB2 Directory table using SQL?

3 Answers  


What is the maximum length of a column name in DB2? 18 or 30 or anything other than these?

4 Answers  


What is a dbrm in db2?

0 Answers  


Can you Average the Characters ?

3 Answers  


How to find the number of rows in db2 tables?

0 Answers  


Categories