Zoned decimals and SQLLDR

From: Jon Waterhouse <jonwaterhouse_at_mail.gov.nf.ca>
Date: 22 May 2002 06:53:14 -0700
Message-ID: <39206c8b.0205220553.45934941@posting.google.com>

I'm using sql loader version 8.1.6.1.

I have dollar values in my ascii dat fixed position file where 6250 represents $62.50.

Part of my control file looks like:

BRTHB3 position(109-116),
NOBENCH position(117-118),
MONPAY position(119-127) zoned(9,2), TOTPMTS position(128-136) zoned(9,2),

when brthb3 is not zero, the decimal values monpay and totpmts come in fine (as 62.5). Data file is as you would expect with the decimal portions always in 126/127 and 135/136. When brthb3 is zero they come in as 6250, as below:

MONPAY TOTPMTS BRTHB3 NOBENCH FIL ---------- ---------- ---------- ---------- ----------

   31250      62500          0          0     466501
   57566     115132          0          0     466503
    62.5        125   19871124          0     466504
    62.5        125   19890602          1     466505
  277870     555740          0          0     466506
   75211     150422          0          0     466509
   48200      96400          0          0     466510
  168.15      492.2   19890303          0     466512
    6250      12500          0          0     466513
   53345     106690          0          0     466515
    6250      12500          0          0     466516

Is this a bug? Is there something I can do about it (I now have access to 8.1.7)?

Thanks,

Jon Received on Wed May 22 2002 - 08:53:14 CDT