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

Explain about cursor stability?

1111


If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?

1222


Is schema the same as database?

1107


Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?

3206


what is a corelated subquerry?

1170


What is bufferpool in db2?

1097


If I have a view which is a join of two or more tables, can this view be updateable?

1185


How do I delete a table in database?

1079


What is the syntax for creating a table in the db2 database?

1150


What is cursor in dbms?

1113


What is cobol db2?

1047


What is the difference between nvl and coalesce?

1108


When do you specify the isolation level?

1073


How can you do the explain of a dynamic sql statement?

1111


Why db2 is called db2?

1108