SQL Loader : Referencing an earlier field

Hello allI
 am doing a bulk load into two tables. The data I am loading is mostly fake (this is a test system), so I am using CONSTANTs for most of the data fields, and using SEQUENCE(MAX,1) to do my keys. There is only one real field that I am loading in from a file. My problem is that the second table has a foreign key reference to the first, and I would like to have to have that sequence number used as the key in my first table as a value in that second table.

I've read in the docs about using :fieldname to reference other fields, but there are no examples of how to make it work with multiple tables.

Brittney McChristy

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Jul 12 2000 - 00:00:00 CEST