SQL*Loader defaultif?

From: Martin, Alan <Alan.Martin_at_GMACInsurance.com>
Date: Mon, 31 Jul 2000 08:48:50 -0400
Message-Id: <10575.113351@fatcity.com>

I've read the manuals and still need help with:

How do I specify, "If the data in the flat file to be loaded for column XXX is NULL, default the column to 'ABC' "? I tried using CONSTANT 'ABC', but that doesn't read (skips) any data from the flat file for that column, which brings up another question. Is there a way to skip (dummy-up) the reading of a column of data? Is DEFAULTIF what I need? Please show an example.

Thanks,
Alan Martin
Database Administrator
GMAC Insurance Personal Lines
Winston-Salem, NC
Alan.Martin_at_GMACInsurance.com

---

Note: The information contained in this message may be priviledged and confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by replying to the message and deleting it from your computer. Thank you.

---

Received on Mon Jul 31 2000 - 07:48:50 CDT