Re: SQL Loader question
From: <HowardParks_at_my-dejanews.com>
Date: Fri, 19 Feb 1999 20:22:01 GMT
Message-ID: <7akh4g$86a$1_at_nnrp1.dejanews.com>
Date: Fri, 19 Feb 1999 20:22:01 GMT
Message-ID: <7akh4g$86a$1_at_nnrp1.dejanews.com>
In article <36CB2D28.423413D8_at_erols.com>,
Scott Mattes <smattes_at_erols.com> wrote:
<SNIP>
> How do I specify the datatype of a field that is 9(5)v99 (hence the data
> looks like 99999 in the source file)? I am guessing for right now that I
> would say
> DECIMAL EXTERNAL(5) (but, how do I tell it the precision - we need 2?).
> Or, can I do INTEGER EXTERNAL(5) and use some function (at load time) to
> divide it by 100?
Here is how to handle it:
fieldname position(1:5) decimal external ":fieldname/100"
Howard Parks
1 Peter 4:10
-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Feb 19 1999 - 21:22:01 CET