Direct path sqlldr and implied decimals problem

From: Paul McGettigan <paulm_at_bass.lkw.com>
Date: 4 Jun 1998 16:49:30 GMT
Message-ID: <6l6j6q$cuo$1@news.ses.cio.eds.com>

I am having a problem reading in implied decimals using direct path sqlldr

I have numeric data coming accross in the format 1234567890-
0000012345+
0000002222-

I have tried to read the data in using the zoned decimal format and while it successfully adds the rows it is ignoring the signs. All rows are loaded as positive numbers.

The fields in the table have been declared as

test_amt number(10,2)

The sqlldr control file is reading the data as

test_amt position(1:11) zoned(10,2)

Using the conventional path sqlldr is possible I know - but due to the size of the datafiles (1GB) is impractical.

Has anyone got any suggestions?

Thanks
Paul Received on Thu Jun 04 1998 - 11:49:30 CDT