You could try:
when (9:12) <> 'UNIX'
However, this will only work if you have fixed field lengths in the input file.
Jonathan Gennick wrote:
> David,
>
> SQL*Loader probably can't help here, because, unfortunatly,
> the WHEN clause is not nearly as flexible as a SQL WHERE
> clause. If no other
David,
SQL*Loader probably can't help here, because, unfortunatly,
the WHEN clause is not nearly as flexible as a SQL WHERE
clause. If no other solution presents itself, you could load
the data into a work table and write some PL/SQL code to
filter out the records that you don't want. You're bett
You could consider doing someting like an awk script against your data
looking for UNIX in that field. Taking this data and piping it to a new
file to be loaded.
-Original Message-
Sent: Monday, July 30, 2001 5:31 PM
To: Multiple recipients of list ORACLE-L
Thanks for the tips on the
Thanks for the tips on the 'when' clause. I guess my dilemma is that my
"FLAG_TEXT" is not the only part of the field I want to filter on. For
example, let's say I want to filter out all the transactions containing the
word UNIX.
aaa,bbb,UNIX45689-2,ccc,ddd
In this case, I cannot use the 'when
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://
ething that would work for you.
Tom Mercadante Oracle Certified Professional
-Original Message-From: David Wagoner
[mailto:[EMAIL PROTECTED]]Sent: Monday, July 30, 2001
2:56 PMTo: Multiple recipients of list ORACLE-LSubject:
SQL*Loader question- Transforming Data
I’m
usin
I’m using SQL*Loader to populate a database table with transaction
records. The data file contains
some transactions that I want to exclude from the load and they all contain the
same text string, something like “xxx,yyy,FLAG_TEXT,xxx,yyy”. Can I use a SQL statement in the SQL*Loader
cont