SQL Loader
From: Adam Edlavitch <aedlavitch_at_tradeinfo.com>
Date: 1996/11/22
Message-ID: <01bbd8ab$fef46f60$54e6b3c6_at_dummy>#1/1
Date: 1996/11/22
Message-ID: <01bbd8ab$fef46f60$54e6b3c6_at_dummy>#1/1
I am trying to read in a file where the target table is not only dependent on the data format, but in the value and order of the data order of the data.
Example:
The data looks like: 1 TEST1 ... ----> Goes to TABLE1 1 HARRY... ----> Goes to TABLE2 2 HARRY... ----> Goes to TABLE3 In this case, the first field delimits the target table. If the value of the first field is 1, then the target table is TABLE1 unless the previous record has the first field withvalue 1, in which case the target table is TABLE2.
Anyone have any ideas?
Thanks for the help,
Adam E.
aedlavitch_at_tradeinfo.com
Received on Fri Nov 22 1996 - 00:00:00 CET