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.
No Answer is Posted For this Question
Be the First to Post Answer
i hav created a program and moved to production but failed to create the table which is been used in the program. the program shows error as soon as it is moved or installed in production or shows error during its runtime. what is the sqlcode for this error
What is the error code -803 ?
in a table consist of 1000 records among that i was updated 145 record how could i know that ..list of recently updated record's and where could i see those updated record's....pls help me out....
What is db2 optimizer?
What are delete-connected tables?
How do you find the maximum value in a column in db2?
How do you retrieve the data from a nullable column?
What is performance tuning db2?
What are db2 tables?
In my table having 100 Rec. How can I delete the 7th row?? (we don't know what is data inside the table)
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
how to resolve -805 . how to see dbrm and package not found