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
Dave,
How
about
INTO TABLE PROJ
FIELDS TERMINATED BY "," OPTIONALLY
ENCLOSED BY '"'
WHENFLAG_TXT != 'yourstringhere'
(EMPNO, ENAME, FLAG_TXT)
Look
at the sample ULCASE5.ctl that is in the ORACLE_HOME\RDBMS\DEMO
directory.
Looks
like it is something that would work for you.
Tom
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 *
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'