Message-Id: <10505.106279@fatcity.com> From: "Burton, Laura L." Date: Mon, 22 May 2000 15:32:32 -0500 Subject: RE: 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_01BFC42C.DFD926BE Content-Type: text/plain; charset="iso-8859-1" Thank you for your response Sunil. I do have the field data type as integer external. I was also adding a format because I did not know that sqlloader would recognize the dash as a negative without a format. I took the format off, ran it again and it worked. Thanks, Laura -----Original Message----- From: Sunil_Nookala@Dell.com [mailto:Sunil_Nookala@Dell.com] Sent: Monday, May 22, 2000 2:58 PM To: Multiple recipients of list ORACLE-L Subject: RE: Negatives in Sqlloader Laura, I did ran into similar problem before. I managed it with data type as INTEGER EXTERNAL on that field in the .ctl file hope this helps. Sunil Nookala -----Original Message----- From: Burton, Laura L. [mailto:BurtonL@prismplus.com] Sent: Monday, May 22, 2000 11:39 AM To: Multiple recipients of list ORACLE-L Subject: 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 ------_=_NextPart_001_01BFC42C.DFD926BE Content-Type: text/html; charset="iso-8859-1" Negatives in Sqlloader
Thank you for your response Sunil.  I do have the field data type as integer external.  I was also adding a format because I did not know that sqlloader would recognize the dash as a negative without a format.  I took the format off, ran it again and it worked. 
 
Thanks,
Laura
 
 -----Original Message-----
From: Sunil_Nookala@Dell.com [mailto:Sunil_Nookala@Dell.com]
Sent: Monday, May 22, 2000 2:58 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Negatives in Sqlloader

Laura,
I did ran into similar problem before.
I managed it with data type as INTEGER EXTERNAL on that field in the .ctl file
hope this helps.
 
Sunil Nookala
-----Original Message-----
From: Burton, Laura L. [mailto:BurtonL@prismplus.com]
Sent: Monday, May 22, 2000 11:39 AM
To: Multiple recipients of list ORACLE-L
Subject: 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