Re: SQL*Loader

From: Jonathan Gennick <jonathan_at_gennick.com>
Date: Mon, 03 Jul 2000 22:23:28 -0400
Message-Id: <10547.111144@fatcity.com>

On Fri, 30 Jun 2000 09:04:33 -0800, you wrote:

> Anyone out there got any idea on how to tell SQL*Loader to ignore =
this
>field??? My other alternative if Pro*C, but that may take a while too.

I can't remember if it was introduced in 8.0 or 8.1, but SQL*Loader now allows you to define a field as FILLER, effectively skipping it. For example:

LOAD DATA
APPEND INTO TABLE gfn_gnis_feature_names (

   gfn_state_abbr CHAR TERMINATED BY "," ENCLOSED BY '"',
   gfn_feature_name CHAR TERMINATED BY "," ENCLOSED BY '"',
   gfn_feature_type CHAR TERMINATED BY "," ENCLOSED BY '"',
   gfn_county_name CHAR TERMINATED BY "," ENCLOSED BY '"',
   gfn_fips_state_code FILLER INTEGER EXTERNAL TERMINATED BY

"," ENCLOSED BY '"',
gfn_fips_county_code FILLER INTEGER EXTERNAL TERMINATED BY "," ENCLOSED BY '"'
)

The FILLER fields won't be loaded. The other fields will be. Sorry that I can't remember the exact release in which =46ILLER was introduced.

Jonathan

jonathan_at_gennick.com =20
http://gennick.com
Brighten the Corner Where You Are Received on Mon Jul 03 2000 - 21:23:28 CDT