Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Loading negative number using SQL*Loader

Loading negative number using SQL*Loader

From: D Huynh <remove.duchuynh_at_pacbell.net>
Date: Fri, 19 Mar 1999 20:36:13 -0800
Message-ID: <ZxFI2.14361$TD3.137937@typhoon-sf.pbi.net>


Hi all,

My input file looks like this:

99999|10|94|1090|229554.00
99999|10|95|-10|-2106.00
601150|5|81|10|1290.00
601150|5|82|10|1290.00

And the control file is:

LOAD DATA
INFILE 'E:\Amgen\TB_FCT_DDD_ACCT_NDC_MTH.txt' INTO TABLE oncdata.TB_FCT_DDD_ACCT_NDC_MTH

( OUTL_ID decimal EXTERNAL terminated by '|',
  PROD_NDC_ID decimal EXTERNAL terminated by '|',
  TIME_MTH_CD decimal EXTERNAL terminated by '|',
  FCT_DDD_ACCT_UNITS decimal EXTERNAL terminated by '|',   FCT_DDD_ACCT_DLLR packed decimal external(10,2))

Somehow, SQL*Loader rejects the negative numbers:

99999|10|95|-10|-2106.00
627000|9|81|-10|-1290.00
698000|9|93|-40|-5288.00
731000|5|76|-20|-2580.00

......

Any help is appreciated Received on Fri Mar 19 1999 - 22:36:13 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US