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

in which tables the transaction details stored? at least two.

5 Answers   Scan Steel,

---

how can we get odd numbered pages in output of a report

2 Answers   Infosys,

---

Can you define an erp system?

0 Answers  

---

In support project one ticket alloted which steps follows manualy tell me ?

0 Answers   BEL, Questam,

---

What multi org tables . example - difference between app table non all table . Po_header and po_headers_all

1 Answers   IBM,

---

---

How to compile the Forms & Reports in Linux Apps Server which are created in WindowsXP client?

1 Answers  

---

What are the Import Programs We need to run after creating Interface table for all modules

1 Answers   Accenture,

---

is UOM maintained at master level or organization level or both?

3 Answers   Scan Steel,

---

How you will Diaplay the Company LOGO In report.Can anyone knows please give solution

8 Answers   TCS,

---

Is it is necessary to create P_CONC_REQUEST_ID parameter in the development of oracle apps reports

2 Answers  

---

In a table their 20 records.I had update 6 records???How can see and retrieve particular 6 records.i.e.,Latest updated.

10 Answers   HCL, TCS,

---

how to avoid duplicate data while uploading data from flatfile to staging table? some validations

5 Answers   Amdocs,

---