Re: SQLLoader question- comma delineated data

From: Colin Sutherland <c.sutherland_at_easynet.com>
Date: 1998/03/26
Message-ID: <6fgqrj$8g$1@apple.news.easynet.net>#1/1

Why not just leave the column for c out - can be done if the data is consistent in it's structure.
Colin

Peter J. Koenig wrote in message <3514baae.95861435_at_nntp.interaccess.com>...
>
>
>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 Thu Mar 26 1998 - 00:00:00 CST