Re: Can this be done with SQLLoader????

<snip>
> >data is a mixture of character, integer, decimal and date (julian dates
> >with lengths of 3, 4, 5, 6 and 7 positions). All of the number fields
> >are non-binary, in other words, if I open the data file with notepad and
> >look at an integer field I see things like '00124' and '10342'. Decimal
> >fields that I want in the table as '9999.99' I see in notepad as
> >'999999'. The date fields are the same way, in notepad I see things like
> >'98100' and '100'.

To load character data into numeric fields, use the decimal external clause. Divide by a power of 10 to handle the implied decimal. For instance, if price is a numeric field and the data looks like "999999": price position(34:39) decimal external ":price/100"

For the dates, if jdate is a date field and the data is like "99062": jdate position(1:5) "to_date(:jdate,\"RRDDD\")" You need to know the date-character conversion strings. DDD is the day-of-year conversion. RR is the year conversion, using a 50-99/0-49 window for the century.

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 Wed Mar 03 1999 - 15:56:19 CET