sql loader question - inserting into multiple tables

From: Tom Reid <thomas_p_reid_at_hotmail.com>
Date: 10 Jul 2002 01:05:32 -0700
Message-ID: <6dfc26f.0207100005.5570fa38_at_posting.google.com>

[Quoted] Hi, I want to load data from a file into two tables depending on the values of the first field in the file but I don't want to actually load the first field.

eg file contains:-
X1234
YABCD
X5678
YWXYZ
-> after the load table1 should have two records, 1234 and 5678
and table2 should have two records, ABCD and WXYZ

Is it possible to do this, I'm running V7.4.3 Received on Wed Jul 10 2002 - 10:05:32 CEST