Answer Posted / obularaju
It not necessary to have DECLARE TABLE statement in
DCLGEN. This is used by the pre-compiler to validate the
table-name, view-name, column name etc., during pre-compile
| Is This Answer Correct ? | 8 Yes | 1 No |
Post New Answer View All Answers
How can you do the explain of a dynamic sql statement?
What is dbrm? What it contains?
How do you eliminate duplicate values in db2?
What is the usage of open cursor command?
Define predicate?
What is buffer pool in the db2 database?
My sql statement select avg(salary) from emp yields inaccurate results. Why?
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?
Can you tell me how can you find out the # of rows updated after an update statement?
What is deadlock in db2?
Why do we need reorg in db2?
How do I delete a table in db2?
What is coalesce in db2?
What is declare cursor?
What is reorg?