Re: Load multiple tables from SQL*Loader

In article <3668A2A3.A1968840_at_mindspring.com>, Dennis Dutcavich <dut_at_mindspring.com> writes
>I am trying to load multiple tables using the same control file. I can
>use two control files and load each table so I know that the data files
>and other constructs are ok. I have two INFILE statements, one for each
>table. Then INSERT and two INTO TABLE statements. The INTO TABLE
>statements are in the same order as the INFILE stmts. What occurs is
>that both INFILES are read and then SQLLDR uses the data from both files
>to load the first table. No other error indications...
>

Dennis,

I think that you should have a look at the WHEN command for sqlldr. I don't have the manual in front of me but you say things like:

INSERT INTO TABLE1
WHEN POSITION(1:6) = 'TABLE1'
        (col1 pos(7:10)... blah blah)

Andy

-- 
Andy Hardy
Senior IT Systems Engineer, Cegelec AEG
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Opinions are mine and do not necessarily reflect those of Cegelec AEG