Sql*loader Problem

From: <brettschneider_at_my-deja.com>
Date: 1999/09/03
Message-ID: <7qool3$hcf$1@nnrp1.deja.com>#1/1

I have a problem that I haven't seen addressed in the sql*loader manual. I will be loading in a bunch of records from an Ascii file. The header record contains a field that has to be loaded with all the other records as a constant. Is there anyway to pick up that field and load it with the rest of the records.

e.g.

chicken,dog,cat
aa,1234,3333
bb,4321,4444
cc,7645,1111

Table should look like:

dog,aa,1234,3333
dog,bb,4321,4444
dog,cc,7645,1111

Thanks for any help.

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Fri Sep 03 1999 - 00:00:00 CDT