sqlload, skipping colums?

Hi,

using sqlload, is it possible to skip certain columns? I.e. the source data containts multiple columns that I don't want to insert into a column in the database. I can't seem to find this anywhere in the documentation.

This is my control-file:

load data
infile *
into table TESTTABLE
fields terminated by ',' optionally enclosed by '"' (

    COLUMN1,

• skip column from source here COLUMN2, COLUMN3 )

BEGINDATA
"1","skip this","2","3"

Thanks,

Bas. Received on Wed Mar 03 1999 - 06:29:56 CST