Re: Zoned decimals and SQLLDR

From: Jon Waterhouse <jonwaterhouse_at_mail.gov.nf.ca>
Date: 23 May 2002 04:06:41 -0700
Message-ID: <39206c8b.0205230306.26ef177b@posting.google.com>

jonwaterhouse_at_mail.gov.nf.ca (Jon Waterhouse) wrote in message news:<39206c8b.0205220553.45934941_at_posting.google.com>...
> 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:

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

Problem was solved after moving to the 8.1.7 version of SQL Loader. This particular problem with zoned decimals was not mentioned as a bug fix for 8.1.7, though ome other zoned decimal problems were. Received on Thu May 23 2002 - 06:06:41 CDT