Problem in loading data into Multiple tables [message #70700] |
Tue, 16 July 2002 03:24 |
pallavi
Messages: 14 Registered: April 2001
|
Junior Member |
|
|
Hi,
I have following control file.
I want to load data into the two tables depending upon some condition.
****************
LOAD DATA
INFILE 'd:work1.csv'
BADFILE 'd:workBAD0001.bad'
DISCARDFILE 'd:workDISCR0001.dsc'
APPEND
INTO TABLE tab1
WHEN identifier = '0092'
FIELDS TERMINATED BY ','
(ID CHAR,
name INTEGER EXTERNAL,
identifier INTEGER EXTERNAL,
desc CHAR
)
INTO TABLE tab2
WHEN identifier = '0011'
FIELDS TERMINATED BY ','
ID CHAR,
name INTEGER EXTERNAL,
identifier INTEGER EXTERNAL
)
***********************
the problem this control file is giving is it loads data into only one table. The first one.
If I change the order of the tables in the control file then whichever is first table, loader will load data only for the first table. It does not load data for the second table.
Why is it behaving so? Is there any parameter which I am missing?
Thanks..
|
|
|
|