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 can u find custom top? where its located? How to find custom top in front end?

1 Answers  

---

What is MO operating units. Why it need to to set this and where .

2 Answers   IBM,

---

How can a process be deployed in soa?

0 Answers  

---

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

3 Answers   Scan Steel,

---

PL/SQL stored procedure parameters?

7 Answers  

---

Can we create tables in apps schema?

0 Answers  

---

What is GLOBAL TEMPORARY TABLE and It's significance ?

3 Answers   KPIT,

---

Assume i have three Procedures defined in a Package Spec. I have created the Package Specification. now i create the Package Body by including the three procedures in addition to that i include a fourth procedure which is not included in my Package Spec. I compile the Package Body. Will the Package body Compile ? What will the end result ? what will happen if the execute the package by calling the 4th procedure ?

7 Answers   Satyam,

---

FLEX FIELDS?

2 Answers  

---

explain registration steps of a concurrent program.

1 Answers   TCS,

---

what is meant by lexical parameter

1 Answers   Wipro,

---

how to print multi lay outs,muti currency,muti language in xml publisher

2 Answers   Deloitte, Oracle,

---