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

How can tablespace be moved to another dasd volume that is allocated for that tablespace?

1222


What is copy pending and check pending in db2?

986


What is dclgen (declaration generator)?

1036


What are bind parameters in db2?

1025


What are the rules for db2 programming?

1071


How do I import a csv file into db2?

970


What is explain plan in db2?

968


What is bind package and plan in db2?

1043


Is the primary key a clustered index?

1127


What is phantom read in db2?

1136


How many types of page locks can be held in db2?

1021


How can you quickly find out the # of rows updated after an update statement?

1025


How to compare data between two tables in db2?

1065


How does cobol compile db2 program?

1034


For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.

1094