When do you use the IMAGECOPY?
Answers were Sorted based on User's Feedback
Answer / tan
IMAGE COPY is done when some update,insert or delete
statements(DML statements ) need to be executed in the
program. Its nothing but taking a copy of the original
table and doing the process.Once the Job completed
successfully, the change will be applied on the original
table. So that, Table can be reset in case of Abends.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / sabahat khan
One use of image copy is in MERGECOPY utility where you
merge Incremental Image copies with one full Image copy to
make an Full image copy.
or
u merge incremental copies.
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / purushothr
it is used to take a back up of the existing files
| Is This Answer Correct ? | 0 Yes | 0 No |
How to find the number of rows in db2 tables?
OUTER JOINS USED TO GET MATCHING AND NONMATCHING ROWS FORM 2 OR MORE TABLES BASED ON COLUMNS. SIMPLE JOINS ALSO DO THE SAME THEN WHAT IS THE USE OF OUTER JOINS.
why db2 is called as universal database?what is the storage capacity of db2v9 n what are the advantages of db2
Can we update view in db2?
if suppose i am having an ACCOUNT table with 3 coloumns ACC. NO,ACC. NAME,ACC. AMOUNT . If a unique index is also defined on ACC.NO and ACC.NAME then write a query to retrieve account holders records who have more than 1 ACC.
What is the latest version of ibm db2?
Is schema the same as database?
What is a predicate?
what is the difference between where clause and having clause
Why select is not preferred in embedded sql programs?
What is clone table?
Can a Db2 table data be retrived through JCL?