RE: Negatives in Sqlloader

From: Burton, Laura L. <BurtonL_at_prismplus.com>
Date: Mon, 22 May 2000 15:32:32 -0500
Message-Id: <10505.106279@fatcity.com>

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_at_Dell.com [mailto:Sunil_Nookala_at_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_at_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"

<!DOCTYPE HTML PUBLIC "-//W3C//DTD W3 HTML//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">

<TITLE>Negatives in Sqlloader</TITLE>
<META content='"MSHTML 4.72.3110.7"' name=GENERATOR>
</HEAD>
<BODY>
<DIV><SPAN class=452382019-22052000><FONT color=#0000ff face=Arial size=2>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.  </FONT></SPAN></DIV>
<DIV><SPAN class=452382019-22052000><FONT color=#0000ff face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=452382019-22052000><FONT color=#0000ff face=Arial
size=2>Thanks,</FONT></SPAN></DIV>
<DIV><SPAN class=452382019-22052000><FONT color=#0000ff face=Arial
size=2></FONT></SPAN><SPAN class=452382019-22052000><FONT color=#0000ff face=Arial size=2>Laura</FONT></SPAN></DIV>
<DIV><SPAN class=452382019-22052000><FONT color=#0000ff face=Arial
size=2></FONT></SPAN><FONT face="Times New Roman" size=2><SPAN class=452382019-22052000><FONT color=#0000ff face=Arial size=2> </FONT></SPAN></FONT></DIV>
<DIV><FONT face="Times New Roman" size=2><SPAN class=452382019-22052000><FONT
color=#0000ff face=Arial size=2> </FONT></SPAN>-----Original Message-----<BR><B>From:</B> Sunil_Nookala_at_Dell.com [mailto:Sunil_Nookala_at_Dell.com]<BR><B>Sent:</B> Monday, May 22, 2000 2:58 PM<BR><B>To:</B> Multiple recipients of list ORACLE-L<BR><B>Subject:</B> RE: Negatives in Sqlloader<BR><BR></FONT></DIV>
<BLOCKQUOTE>

<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=377053818-22052000>Laura,</SPAN></FONT></DIV>

    <DIV><FONT color=#0000ff face=Arial size=2><SPAN class=377053818-22052000>I 
    did ran into similar problem before.</SPAN></FONT></DIV>
    <DIV><FONT color=#0000ff face=Arial size=2><SPAN class=377053818-22052000>I

managed it with data type as <STRONG>INTEGER EXTERNAL </STRONG>on that field in the .ctl file</SPAN></FONT></DIV> <DIV><FONT color=#0000ff face=Arial size=2><SPAN class=377053818-22052000>hope this helps.</SPAN></FONT></DIV> <DIV><FONT color=#0000ff face=Arial size=2><SPAN class=377053818-22052000></SPAN></FONT> </DIV> <DIV><FONT color=#0000ff face=Arial size=2><SPAN class=377053818-22052000>Sunil Nookala</SPAN></FONT></DIV> <BLOCKQUOTE style="MARGIN-RIGHT: 0px">

        <DIV align=left class=OutlookMessageHeader dir = ltr><FONT face=Tahoma 
        size=2>-----Original Message-----<BR><B>From:</B> Burton, Laura L. 
        [mailto:BurtonL_at_prismplus.com]<BR><B>Sent:</B> Monday, May 22, 2000 
        11:39 AM<BR><B>To:</B> Multiple recipients of list 
        ORACLE-L<BR><B>Subject:</B> Negatives in Sqlloader<BR><BR></DIV></FONT>
        <P><FONT face=Arial size=2>Using SqlLoader, has anyone handled negative 
        amounts?&nbsp; I have downloaded into a text file the amounts with a 
        negative sign in the first position of the field.&nbsp; If it is not 
        negative there is a blank there.&nbsp; I am having trouble gettting 
        sqlldr to run.&nbsp; Anyone have any experience with this?&nbsp; How do 
        you 'format' the .ctl member to recognize the '-' as being a 
        negative?</FONT></P>
        <P><FONT face=Arial size=2>Thank you in advance,</FONT> </P>
        <P><FONT face=Arial size=2>Laura</FONT>

Received on Mon May 22 2000 - 15:32:32 CDT