Answer / rajiv

LOAD DATA
APPEND
DISCARDMAX 9999999
INTO TABLE UPLOAD_HDR
WHEN agreementno='~'
FIELDS TERMINATED BY ","
(
AGREEMENTNO CHAR(20),
FILENAME CHAR(30),
BATCHID constant 112)
INTO TABLE UPLOAD_TMP
WHEN agreementno <>'~'
FIELDS TERMINATED BY ","
TRAILING NULLCOLS
(
AGREEMENTNO POSITION(1) CHAR(20),
EMI_AMT INTEGER EXTERNAL(16),
BATCHID constant 112)

Answer / emmanuel - tcs

A Small changes in above control file

Add below insert stmt to above CTL File
Insert into Table Tab_name_1 -- This is for one table
Insert into Table Tab_name_2 -- This is for Second Table

First mention first table column and mention second table
columns

Answer / bobbyiiit

Using "When"

we use "When" condition to load data into multiple tables.

Syntax:

Load Data infile '&1'
Insert into table table1
(
.
.
.
.
)
Insert into table table2
when <condiation>
(
.
.
.
);

please explain open interface import

2 Answers  

---

Is that Possible To create package without Specification , If Yes Give any Examples

2 Answers   PWC,

---

can we use commit in trigger? If yes how?

2 Answers   Cap Gemini, TCS,

---

Tell me some thing about SQL-LOADER.

2 Answers   IBM,

---

I want to print output in portrait style?where i have to change the settings?

2 Answers   Sierra Atlantica,

---

What are the files we submit while your program move to testing instance?

4 Answers   Cap Gemini,

---

in order to run utl_file package we need to give any specific path? if yes what is that?where u will run utl_package?

1 Answers   KPMG,

---

what is item status? name the related table.

1 Answers   Scan Steel,

---

How we print the multi language in report?can any one give me step bye step explanation.

2 Answers   HCL, IBM, Tech Mahindra,

---

How many schemas we have? how many you have used?

0 Answers  

---

what are the error tables in OM

2 Answers   Fujitsu,

---

What are different execution methods of executabls?

1 Answers   Genpact, TCS,

---