Interested to Buy Any Domain ? << Click Here >> for more details...
How do you Load a table ?? and what is Load replace ?
- 2 Answers
- 33384 Views
- Xansa, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / karthikeyan@ibm
In General, system will have standard PROC(DSNUPROC) to
load the Table.Three symbolic parameter needs to be passed.
But only one parameter is mandatory SYSTEM=DB2T(subsystem).
Let me explain the Proc. The Proc contains a step with
DSNUTILB as program to load the table. In Parms, pass the
DB2 susbsystem. In SYSREC ddname points to the dataset that
contains the records to be load.SYSIN ddname points to the
control card that is used to load the table.Control card
contains information like tablename to be loaded, Position
of the column and other options like LOAD with REPLACE or
Load with RESUME, ENFORCE YES OR NO and LOG Yes OR NO.
When you want to specify REPLACE option, all the records or
rows in the table are deleted before loading and RESUME
option will retain the old records or rows in the table.
The tablespace will put in COPY PENDING status when you
load the table with Option LOG NO.
//DSNUPROC EXEC PGM=DSNUTILB,REGION=6144K,PARM='DB2'
//SYSREC DD DSN=&LOADdataset,DISP=OLD
//SYSIN DD DSN=&Controldataset,DISP=OLD
| Is This Answer Correct ? | 26 Yes | 3 No |
Answer / 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 |
What are host variables in db2?
Explain the use of the WHERE clause.
What is error -818 in db2. where can you find the timestamp of the DBRM and the source code.( precompile puts the timestamp on dbrm and source code correct?)
in a table consist of 1000 records among that i was updated 145 record how could i know that ..list of recently updated record's and where could i see those updated record's....pls help me out....
What is the maximum length of a column name in DB2? 18 or 30 or anything other than these?
Why cursor is used in db2?
What is usage pointer in cobol?
can any body explain about plan and pakage in detail....
What are some characteristics of columns that benefit from indexes?
Which catalog tables contain authorization information?
Is it Possible to declare or create a cursor for UPDATE of table? If yes tell me how? If no Tell me why?
Explain what are the various isolation levels possible?
COBOL 
