| sql loader load data into multiple tables [message #60414] |
Fri, 06 February 2004 03:56  |
Sascha
Messages: 15
Registered: November 2002
|
Junior Member |
|
|
i have a "|" separated file the 1st column of which signifies an individual record type . The record types are variable length ie record type 1 has around 100 chars while 2 has around 50 etc...
We plan to load this data in multiple tables using a loader script. The loader script works fine but loads data in only the first table . The other record types get rejected .
Some sample records from the file is as follows
1?|N?-10-01|CON?-10-07?OTOFF?|D?.29��.53|.00ӚӘӘӘ
2?ә|N|D|XT?*1111��.60
Please note 1| and 2| indicate the record types mentioned above .
our control file looks like this
LOAD DATA
into table summ_order
when (1) = '1'
fields terminated by "|"
(
Record_Identifier,
OPS_Order_ID,
Record_Status,
Transaction_Date,
Booking_Status ,
Departure_Date ,
Branch_Code ,
Consultant_Ref ,
DC_Indicator ,
Total_GrossCost ,
Total_NetCost ,
Total_Discounts ,
No_of_Adults ,
No_of_Senior_Citizens,
No_of_Children ,
No_of_Infants
)
into table pay_order1
when (1) = '2'
fields terminated by "|"
(
Record_Identifier,
OPS_Order_ID,
Payment_Record_ID,
Record_Status,
DC_Indicator,
Payment_Method,
Payment_Ref,
Payment_Amount
)
What should I do??
Sascha
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
