How would you find out the total number of rows in a db2 table?
No Answer is Posted For this Question
Be the First to Post Answer
What is the purpose of the WHENEVER statement?
How we create a tables in DB2 ?Previously client has using 7 letters for user id,now he wants to increase the letters from 7 to 12 for user id.How we can do it?
What is the max length of sqlca?
What is cursor stability in db2?
I have a main program (A) where we delete some rows in table in a cursor, and we commit it in sub program(B). What will happen - will we get an error or not?
Compare a subselect to a join?
in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?
If I have a view which is a join of two or more tables, can this view be updatable?
Can we install 2 different versions of Db2 on same mainframe?
Where are plans stored?
What are the Isolation levels possible ?
how to delete perticular row from table for ex. how you will delete 3rd row from table please answer THANKS IN ADVANCE