How do you Load a table ?? and what is Load replace ?
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 the maximum size of a char data type in db2?
What is a db2 package?
What does reorg do in db2?
What is the difference between bind and rebind in db2?
Is ibm db2 free?
Can we update view in db2?
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
Which components manage deadlocks in db2?
How to fetch the last row from the table in SQL (db2)?
What is drop table?
Define sqlca.
How do I connect my db2 database to ibm?
How can tablespace be moved to another dasd volume that is allocated for that tablespace?
What is release/acquire in bind?
What is database alias db2?