Message-Id: <10505.106236@fatcity.com> From: "Burton, Laura L." Date: Mon, 22 May 2000 10:17:34 -0500 Subject: Negatives in Sqlloader This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01BFC400.DDCE5316 Content-Type: text/plain; charset="iso-8859-1" Using SqlLoader, has anyone handled negative amounts? I have downloaded into a text file the amounts with a negative sign in the first position of the field. If it is not negative there is a blank there. I am having trouble gettting sqlldr to run. Anyone have any experience with this? How do you 'format' the .ctl member to recognize the '-' as being a negative? Thank you in advance, Laura ------_=_NextPart_001_01BFC400.DDCE5316 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Negatives in Sqlloader

Using SqlLoader, has anyone handled = negative amounts?  I have downloaded into a text file the amounts = with a negative sign in the first position of the field.  If it is = not negative there is a blank there.  I am having trouble gettting = sqlldr to run.  Anyone have any experience with this?  How do = you 'format' the .ctl member to recognize the '-' as being a = negative?

Thank you in advance,

Laura