SQL*Loader Question

From: Vijay Damodaran <vijayd_at_nortel.com>
Date: Tue, 22 Sep 1998 14:08:59 -0500
Message-ID: <3607F5CA.5F276C2A_at_nortel.com>



 

Hi, [Quoted]

I get a comma separated file containing thousands of records. Each row contains 29 columns. I need to
load the data into a table, but I need only 11 of the 20 columns i.e. the table has only 11 columns. The
columns to skip are distributed across the entire row. If they were at the end of the row, then the
columns get skipped automatically. But, how do I tell SQL*Loader to ignore columns via the control
file?

My current control file looks like this (all the fields called "dummy" are the ones that I want to ignore).
It obviously doesn't work, because the dummy columns are not in the table.

Thanks,

regards,
VJ.

---------------------------------------------------------

load data
infile '/tmp/people.list'
replace
into table buf_people
fields terminated by ','
(unique_key,
 dummy1,
 record_type,
 status,
 emp_role,
 dummy2,
 dummy3,
 dummy4,
 mgr_unique_key,
 dummy5,
 dummy6,
 dummy7,
 dummy8,
 dept,
 loc,
 dummy9,
 dummy10,
 dummy12,
 dummy13,
 dummy14,
 initials,
 dummy15,
 dummy16,
 clastname,
 cfirstname,
 dummy17,
 dummy18)

-- 
Vijay Damodaran
vijayd_at_nortel.com
Work: (972) 685-8150
  Received on Tue Sep 22 1998 - 21:08:59 CEST

Original text of this message