Re: SQL*LOAD problem

Let's say you have field1 declared the following way in SQL Loader control file:

field1 EXTERNAL INTEGER

You can add SQL functions when defining fields. Thus you can change the value of the field before loading, supressing the + sign:

field1 EXTERNAL INTEGER "replace(:field1,'+')"

Beware that including SQL functions in the control file, prevents SQL Loader from loading data in DIRECT mode. This workaround will enable you to carry on your work, but if you can, study SQL Loader syntax and look for Number Formatting features provided, since this isn't the most elegant solution.

Hope this helps,

Nuno Guerreiro

On Tue, 01 Sep 1998 16:02:26 -0400, Royce Franklin Medlock <medlocrf_at_dunx1.ocs.drexel.edu> wrote:

>I am trying to import EXTERNAL INTEGER data into a number field in a
>table. The problem is that the data is signed, that is there is a + if
>it is positive and - if it is negative. SQL*Load does not like the +
>and rejects the data. The data is delimited and not fix-format. I am
>wondering if anyone knows how I can get SQL*load to recognize signed
>numbers.
>
>--
>R. Franklin Medlock, Jr.
>Database Administrator
>Office of Information Resources and Technology
>Drexel University
>
>Phone: (215) 895-1297 Fax: (215) 895-6677
>
>Frankie.Medlock@drexel.edu, http://www.drexel.edu
>
>
>
Received on Wed Sep 02 1998 - 00:00:00 CDT