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>
(
.
.
.
);

How do u customize the Reports?

1 Answers  

---

In thet custom.pll what are the events we can write.

2 Answers   IBM,

---

How can you achieve loose coupling in soa framework?

0 Answers  

---

IN GL,AP,PO,AR WHICH MODULE DOESNOT HAVE _ALL TABLES THEN WHY?

7 Answers   Accenture,

---

How many typres of Purchase order and what are those.

2 Answers   Accenture,

---

how to create requst set in oracle apps and how to send muliple requests at a time,

1 Answers   Genpact,

---

what is flexfield qualifier?

3 Answers  

---

Is SOB is attached with Business grp ?

2 Answers   Convergys,

---

Hi, can anybody tell me where is the requirement of Oracle Apps (functional+technical) in industry,Iwant to join there,If possible than call me---9313174232

0 Answers  

---

How to migrate .rdf file from dev instance to test instance?

3 Answers   Accenture, Oracle, TCS, Tech Mahindra, Unisoft Infotech,

---

What is template?

2 Answers  

---

In custom.pll what are the events we can Not write.

1 Answers  

---