Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

in my table i will update only 100 record among 1000
records i need to display recently updated record'.....can u
tell me where those records are stored how can i display
those records...?if there is any sql query pls let me know....?

Answer Posted / adarsha

Use the DB2 COPY Utility with Incremental Image copy.. which
give you the latest update done to a prticular table/table
space from last update .. below is the utility step

COPY TABLESPACE DSN8D51A.DSN8S51E
FULL NO
SHRLEVEL CHANGE

Use jcl for that

Is This Answer Correct ?    2 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Discuss about db2 bind?

1052


In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?

993


What is the connection string to connect to the DB2 Database ?

1062


How can the duplicate values be eliminated from db2 select?

1044


What is the syntax for seeing the columns and data types of a table in the db2 database?

1089


Describe major components of db2?

1044


Can you use max on a char column?

1031


Is db2 a mainframe?

970


What are concurrency issues?

1032


How do I import data from excel to db2?

1014


What is a db2 tablespace?

1002


Define predicate?

1069


Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?

1033


What's The Error Code For Unique Index Voilation?

1155


How to check last update on table in db2?

1004