SQLLoader and implied decimals

From: Brian Lawler <brian.lawler_at_mci.com>
Date: 1997/08/01
Message-ID: <33E2454E.3A21_at_mci.com>#1/1


Please help.
How can I use SQLLoader to read a text file with an implied decimal. E.g

   Company ABC 12345
   Company XYZ 8999
   My Company 34555
In this example, the text "12345" is intended to be interpreted as $123.45.
I can control the target table and use and field/column type I want in the target table if that helps.
I've tried using DECIMAL EXTERNAL, DECIMAL, etc. in the SQLLoader control file but no luck yet. E.g.:

	load data into my_table
	(
		company_name  position(1:11)  char,
		amount        position(15:19) decimal
	)
Received on Fri Aug 01 1997 - 00:00:00 CEST

Original text of this message