Message-Id: <10677.121825@fatcity.com> From: "Adisekaran Murugaian" Date: Sat, 11 Nov 2000 08:04:35 -0500 Subject: SQL Loader - Control File This is a multi-part message in MIME format. ------=_NextPart_000_000E_01C04BB6.0822BFC0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable HI All, How do I write the control file to load all the records when=20 particular position IS NOT NULL 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 I have more than 10 million records, I want to load only if there is any = value in particular postion. Thank you, Adi. ------=_NextPart_000_000E_01C04BB6.0822BFC0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
HI All,
 
How do I write the control file to load all the = records when=20
particular position IS NOT NULL
 
WHEN (829:830)  =3D' '    -- is = not working=20 because this condition check for space not for NULL
WHEN (829:830)  IS NOT=20 NULL      -- will not work    = only=20 =3D & <>  is allowed
 
 
I have more than 10 million records, I want to load = only if=20 there is any value in particular postion.
 
Thank you,
Adi.