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

Name the various locking levels available?

618


What is the maximum size of varchar data type in db2?

634


List out the three types of page locks that can be held.

674


can we view the access paths created by dbrm ? how ? thx

6211


When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?

3106






Which is faster delete or truncate?

661


What is blu acceleration in db2?

590


What is precompiler in db2?

577


What is access path in db2?

548


What is package in db2 mainframe?

544


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

576


Mention a credible reason why select* is never given preference in an sql program that has been embedded.

696


What is concurrency?

695


Describe major components of db2?

624


Explain about rct.

634