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
How do I optimize a query in db2?
What is a dbrm in db2?
How to check table size in db2 sap?
Before you give the explain statement, what are the prerogatives?
What is alias in db2?
What is difference between alias and synonym in db2?
What is concurrency?
Can you tell me how can you find out the # of rows updated after an update statement?
What is dclgen (declaration generator)?
What is coalesce in db2?
What is the max length of sqlca?
Why do we use cursor?
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.
Can you use max on a char column?
How would the varchar column remarks defined?
