sql loader query

[death]

hi, i have a control file that takes in duplicated column names. Is there anyway to skip one of them, as in when the sql loader sees that column name, skips it and continues to load the rest of the data but it will take in the data at the next occurance of that duplicated column.
Thanks.

 

[listener22]

Can you tell sql*loader to ignore one of the fields by
altering your POSITION clause in the column specification?
(*+n) skips n characters before reading a field value.

Jim

oracle, vb, some javascript

 

[MikeLacey]

Have you considered processing the data file, with an awk script perhaps, before giving it to sqlldr?

Mike
michael.j.lacey@ntlworld.com

http://www.cargill.com/

 

[death]

hi, I am sorry but I am new to all this. What is an awk script?

 

[MikeLacey]

An awk script is a small program, people often use awk or perl to do jobs like this, formatting text files and the like.

Once you're familiar with awk or perl it makes the kind of job you're thinking of quite easy, so you can give programs like sqlldr the data file of their dreams and not have to fiddle with them too much toget them to work. It does, of course take a bit of work to get to that stage.

If you're on a unix server you will have awk and quite likely perl, if you're on NT you probably won't have awk and either have perl already or could get it quite easily.

What platform are you on?

Mike
michael.j.lacey@ntlworld.com

http://www.cargill.com/