Re: SQL*Loader mutliple when clauses for the same column

John,

I haven't done it in a while, but use multiple insert/append statements each with a different when clause in the same controlfile. So in your case you would have three statements, each with a different when clause for each value of STATUS.

HTH,

• Anita
  • jfedock_at_ixl.com wrote:
    > Hello All,
    >
    > Looking for help using mutiple when clauses for the
    > same column with
    > SQL*Loader.
    >
    > For example, I want to load records that have a
    > status of A, B or C.
    >
    > Within sql*loader, WHEN (STATUS = 'A') OR (STATUS =
    > 'B') OR (STATUS = 'C')
    > INVALID.
    > and WHEN (STATUS = 'A') AND (STATUS = 'B') AND
    > (STATUS = 'C') is technically
    > correct, but it will never load since the status
    > cannot be 3 things at once.
    >
    >
    > Note that it is the SAME column being used each
    > time. WHEN dept=10 AND
    > emp=22 works fine (since they are differnt columns).
    >
    >
    > I also tried an IN clause and that failed. A call
    > to Oracle support had no
    > alternatives.
    >
    > I can't believe there is not a work around.
    >
    > Any ideas?
    >
    >
    > John Fedock
    > iXL, Inc.
    > Glen Allen, VA 23060
    >
    > <mailto:jfedock_at_ixl.com> jfedock_at_ixl.com
    > http://www.ixl.com <http://www.ixl.com/>
    >
    > This message is intended only for the use of the
    > addressee and may contain
    > information that is PRIVILEGED and CONFIDENTIAL. If
    > you are not the intended
    > recipient, dissemination of this communication is
    > prohibited. If you have
    > received this communication in error, please erase
    > all copies of the message
    > and its attachments and notify us immediately.
    >
    > --
    > Author:
    > INET: jfedock_at_ixl.com
    >
    > 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: ListGuru_at_fatcity.com (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).
    

    ---