SQLLoader question- comma delineated data

From: Peter J. Koenig <koenig_at_nospamm.interaccess.com>
Date: 1998/03/22
Message-ID: <3514baae.95861435@nntp.interaccess.com>#1/1

I am loading comma separated records from a file using SQLLoader. There is more data per record than I want to store. How do I skip a field? For example, my table has 3 fields, A, B, and C. My data is 1,2,9,3. I want to load 1 into A, 2 into B, and 3 into C and skip 9 entirely. What can I put in a control file like the following to skip the third field?

OPTIONS (ERRORS=9999)
LOAD DATA
APPEND
INTO TABLE cdb_data
(

A                          CHAR(20) TERMINATED BY ',',
B                          CHAR(20) TERMINATED BY ',',
?????                 CHAR(20) TERMINATED BY ',',
C                          CHAR(20) TERMINATED BY ','

)

Peter Koenig
koenig_at_interaccess.com Received on Sun Mar 22 1998 - 00:00:00 CST