Path: news.easynews.com!easynews!nntp.flash.net!newspeer.monmouth.com!uvsq.fr!freenix!wanadoo.fr!proxad.net!proxad.net!feeder2-1.proxad.net!news2-1.free.fr!not-for-mail
From: "Antoine Tissier" <nospam@nospam.net>
Subject: WHEN OTHERS DO NOTHING
Date: Sun, 07 Jul 2002 11:27:58 +0200
Newsgroups: comp.databases.oracle.misc
Organization: Datacep
Message-ID: <20020707.112757.213975407.10866@nospam.net>
User-Agent: Pan/0.9.7 (Unix)
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
Lines: 20
NNTP-Posting-Date: 08 Jul 2002 12:08:24 MEST
NNTP-Posting-Host: 194.51.120.130
X-Trace: 1026122904 news2-1.free.fr 242 194.51.120.130
X-Complaints-To: abuse@proxad.net
Xref: easynews comp.databases.oracle.misc:83925
X-Received-Date: Mon, 08 Jul 2002 03:18:12 MST (news.easynews.com)

Hi,

I d like to load a table with sqlloader.

The file has a header and a footpage.

So, what i am looking for is a thing like

DEFAULTIF
	DO NOTHING

I managed to write the when statement that checks if is the body,
the footpage or the header. But i do not know how to ask him to do
nothing.

Obviously, if i only write the when statement for the body, the exit code
won't be zero, and i need to know if the load has been successful.

Thx in advance
Antoine