How do you Load a table ?? and what is Load replace ?
- 2 Answers
- 32842 Views
- Xansa, I also Faced
- E-Mail Answers
Answer Posted / sasi
load a Table using LOAD UTILITY provided by db2.
LOAD REPLACE
replace old data in the Table(resets a tablespace and
related indexes to empty before loading)
| Is This Answer Correct ? | 18 Yes | 3 No |
Post New Answer View All Answers
What is precompiler in db2?
What is the clustering index in the db2 database?
How is deadlock resolved?
When do you specify the isolation level?
Before you give the explain statement, what are the prerogatives?
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
How to compare data between two tables in db2?
What is copy pending and check pending in db2?
How to find primary key of a table in db2?
Give the name of some fields form sqlca.
How can you count the number of rows from a table tab?
Explain the function of data manager.
What is the physical storage length of the data types: date, time, timestamp in the db2 database?
What is dbrm?
What is the use of db2 optimizer?
