How can you do the explain of a dynamic sql statement?
No Answer is Posted For this Question
Be the First to Post Answer
how to u check the query is executing or not ?where will u check for sqlcode ?
What are the advantages of using a PACKAGE?
What is host variable?
Comment whether the cursor is closed during commit or not.
What is a root page?
How to view db2 table structure?
What DB2 Catalog column tell you when an index needs table reorganized ?
what is the syntax for FOR UPDATE CLAUSE in cursor declaration and how can u update using cursor? is it possible to update multiple rows at a time.
What is the difference between Primary key and unique index?
In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?
select * from orders where odate between '2010-01-01'and '2010-03-31' How do u fetch this into cursor?
In db2, how do you insert multiple rows in 1 query using a.) Cursors, b.) Normal query?? Give syntax for both.