SQL Loader

From: Adam Edlavitch <aedlavitch_at_tradeinfo.com>
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                         with

value 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