AW: SQL Loader - Control File

From: <Brigitte.Tuerk_at_kaufhof.de>
Date: Mon, 13 Nov 2000 10:43:13 +0100
Message-Id: <10679.121854@fatcity.com>

How declare you NULL in the File-Column. NULL can be all or nothing. = Use a
pseudonym for NULL in your file , perhaps '**********'. Now you can ask = for
the condition .

	WHEN (829:830)  <> '*********'=20
	I hope,that helps

Mit freundlichen Gr=FC=DFen

Brigitte T=FCrk
KAUFHOF WARENHAUS AG
> IT-Controlling Datenbankadm.

Leonhard-Tietz-Str. 1
D-50676 K=F6ln
Tel.:+49 (0)221 223-21 88
eMail: Brigitte.Tuerk_at_kaufhof.de

> -----Urspr=FCngliche Nachricht-----
> Von: Adisekaran Murugaian [SMTP:adisekarm_at_home.com]
> Gesendet am: Samstag, 11. November 2000 14:05
> An: Multiple recipients of list ORACLE-L
> Betreff: SQL Loader - Control File=20

>=20

> HI All,
> =20
> How do I write the control file to load all the records when=20
> particular position IS NOT NULL
> =20
> WHEN (829:830) =3D' ' -- is not working because this condition =
check for
> space not for NULL
> WHEN (829:830) IS NOT NULL -- will not work only =3D & <> =
is
> allowed
> =20
> =20
> I have more than 10 million records, I want to load only if there is =
any
> value in particular postion.
Received on Mon Nov 13 2000 - 03:43:13 CST