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
Which is faster delete or truncate?
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
How to compare data between two tables in db2?
Comment whether the cursor is closed during commit or not.
What is the usage of open cursor command?
what are bind concepts in db2 cobol?
how 2 resolve the -311 sqlcode
why db2 is called as universal database?what is the storage capacity of db2v9 n what are the advantages of db2
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....
How do you filter out the rows retrieved from a Db2 table ?
Can we declare DB2 HOST variable in COBOL COPY book?
What is a view? Why use it?