Interested to Buy Any Domain ? << Click Here >> for more details...
How do you Load a table ?? and what is Load replace ?
- 2 Answers
- 33389 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 |
Explain about cursor stability?
How can the firstname and the lastname from the emp table be concatenated to generate complete names?
i know the stpes 2 create an executable CICS/DB2 cobol code. 1. DB2 Precompiler converts the SQL Statements into COBOL API statements and creates another member with Acess plans. CodeA results in CodeB (code with API calls) & CodeC ( Access Plans ) 2.Code B is compiled/linked 2 create an exceutable.(codeE) 3.Now CodeC is binded to the database on which CodeE will be run. Can somebody provide me the sample JCLs for precompile/compile/link/bind.
Can we declare cursor in Procudere division or open the cursor in the Working storage section. Is there any particular rules in the usage of cursors lifecycle
Mention and explain the contention situations caused by locks?
If the base table underlying a view is restructured, eg. attributes are added, does the application code accessing the view need to be redone?
What is database alias db2?
What is db2?
For Read Stability locks are not applicable for phantoms, What is Phantoms?
How can we define a table? How can we apply SEARCH ALL on it ?
what is Static and dynamic linking
How do you leave the cursor open after issuing a COMMIT? (for DB2 2.3 or above only)
COBOL 
