How do you Load a table ?? and what is Load replace ?
- 2 Answers
- 32550 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 db2 instance?
in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?
Are view updateable?
Name the lockable units in DB2?
Why do we use cursor?
What is the function of logging in the db2 database?
How would you find out the total number of rows in a db2 table?
what is utility for parm lib
How do you simulate the explain of an embedded sql statement in spufi/qmf?
What is the syntax for creating a table in the db2 database?
What do you mean by cursor?
How can you classify the locks in db2?
What is db2 look?
What is the physical storage length of the data types date, time, and timestamp?
What is bind in db2?
