Hello David,
You need to use the WHEN clause. Look at the example in the
middle of page 147. If an input record doesn't match the
conditions you specify following WHEN, it simply isn't
loaded.
Best regards,
Jonathan Gennick
mailto:[EMAIL PROTECTED] * 906.387.1698
http://Gennick.com * http://MichiganWaterfalls.com * http://MetalDrums.org
Monday, July 30, 2001, 2:56:22 PM, you wrote:
DW> I'm using SQL*Loader to populate a database table with transaction records.
DW> The data file contains some transactions that I want to exclude from the
DW> load and they all contain the same text string, something like
DW> "xxx,yyy,FLAG_TEXT,xxx,yyy". Can I use a SQL statement in the SQL*Loader
DW> control file to filter out those transactions? Something that functions
DW> like this pseudocode:
DW> if field like '%FLAG_TEXT%' then null;
DW> else load;
DW> I've been reading the new Oracle SQL*Loader book by Gennick and Mishra which
DW> is a good book, but I'm still uncertain about this.
DW> Thanks,
DW> David B. Wagoner
DW> Database Administrator
DW> Arsenal Digital Solutions Worldwide Inc.
DW> 4815 Emperor Blvd., Suite 110
DW> Durham, NC 27703
DW> Tel. (919) 941-4645
DW> Fax (919) 474-0695
DW> Email <mailto:[EMAIL PROTECTED]>
DW> mailto:[EMAIL PROTECTED]
DW> Web <http://www.arsenaldigital.com/> http://www.arsenaldigital.com/
DW> *** NOTICE ***
DW> This e-mail message is confidential, intended only for the named
DW> recipient(s) above and may contain information that is privileged, work
DW> product or exempt from disclosure under applicable law. If you have
DW> received this message in error, or are not the named recipient(s), please
DW> immediately notify the sender at (919) 941-4645 and delete this e-mail
DW> message from your computer. Thank you.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jonathan Gennick
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
