Answer Posted / mahyn
select * from tablename
order by primary_key desc
fetch first 5 rows only
with ur;
can be one way...
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
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.
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?
What is dclgen (declaration generator)?
What is precompiler in db2?
How to run db2 command in windows?
Explain about mirror activator disk mirroring?
How many databases can be created inside an instance in db2 ?
What is the use of with ur in db2?
What are the bind parameters ibm db2?
Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.
What is runstats db2?
What are the contents of dclgen?
What are db2 objects?
How can you do the explain of a dynamic sql statement?
What language is db2 written in?
