SQL Loader - Control File

From: Adisekaran Murugaian <adisekarm_at_home.com>
Date: Sat, 11 Nov 2000 08:04:35 -0500
Message-Id: <10677.121825@fatcity.com>

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

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2314.1000" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT size=3D2>HI All,</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=3D2>How do I write the control file to load all the =
records when=20
</FONT></DIV>
<DIV><FONT size=3D2>particular position IS NOT NULL</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>WHEN (829:830)  =3D' '    -- is =
not working=20
because this condition check for space not for NULL</FONT></DIV>
<DIV><FONT size=3D2><FONT size=3D2>WHEN (829:830)  IS NOT=20
NULL      -- will not work    = only=20
=3D & <>  is allowed</FONT></FONT></DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV><FONT size=3D2>I have more than 10 million records, I want to load =
only if=20
there is any value in particular postion.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=3D2>Thank you,</FONT></DIV>
<DIV><FONT size=3D2>Adi.</FONT></DIV>
<DIV> </DIV></BODY></HTML>
Received on Sat Nov 11 2000 - 07:04:35 CST