REPLACE in SQL Loader [message #69582] |
Tue, 05 February 2002 06:39 |
Shantan
Messages: 2 Registered: February 2002
|
Junior Member |
|
|
Hi,
I am trying to load data from a file into a temporary table using SQL Loader and REPLACE. But, the data from the file doesn't get loaded in the same order as it is in the file. I need to have the data loaded into the table in the same order as in the file because there are headers and matching lines for these records. This is the SQL Loader script I'm using:
LOAD DATA
INFILE '&1'
REPLACE
INTO TABLE zce_ukicitibank_temp
TRAILING NULLCOLS
(
FIELD1 CHAR TERMINATED BY "@",
FIELD2 CHAR TERMINATED BY "@",
FIELD3 CHAR TERMINATED BY "@",
FIELD4 CHAR TERMINATED BY "@",
FIELD5 CHAR TERMINATED BY "@",
FIELD6 CHAR TERMINATED BY "@",
FIELD7 CHAR TERMINATED BY "@",
FIELD8 CHAR TERMINATED BY "@",
FIELD9 CHAR TERMINATED BY "@",
FIELD10 CHAR TERMINATED BY "@",
FIELD11 CHAR TERMINATED BY "@",
FIELD12 CHAR TERMINATED BY "@",
FIELD13 CHAR TERMINATED BY "@",
FIELD14 CHAR TERMINATED BY "@",
FIELD15 CHAR TERMINATED BY "@",
FIELD16 CHAR TERMINATED BY "@",
FIELD17 CHAR TERMINATED BY "@",
FIELD18 CHAR TERMINATED BY "@",
FIELD19 CHAR TERMINATED BY "@",
FIELD20 CHAR TERMINATED BY "@"
)
Can anybody help me?
Thanks & Regards,
Shantan
|
|
|
|
|