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
What is DCLGEN ?
How can you do the explain of a dynamic sql statement?
How do you select a row using indexes in db2?
db2 query I have one table with the following details. SNO SNAME DOJ ------ -------------------- ---------- 10 KRISH 2007-03-19 20 REDDY 2007-05-19 30 RRRRR 2007-05-19 40 BBBBB 2008-05-19 50 CCCCC 2009-05-19 60 JJJJJ 2009-05-19 70 JJJJJ 2004-05-19 i want the output in the following format:( no of students joined in each year(no nedd to consider about month and date) year count --------- ---------- 2004 1 2007 3 2008 1 2009 2
Bind concepts in DB2 cobol
10 Answers IBM, TCS, TRD, Virtusa,
What happens to a tablespace when its recovery infromation has been removed and a full recovery is no longer possible?
What is ibm db2 database?
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
What is dpf in db2?
Explain the use of the WHERE clause.
What is phantom read in db2?
What is sqlcode -922 ?