Sqlloader: All database in one single plain text file
Date: 25 Feb 2004 10:04:21 -0800
Message-ID: <8e5d4aee.0402251004.5fbc6c7f_at_posting.google.com>
Hi all,
I'm trying to use sqlloader to import a database with multiple
different tables which has been exported to one single plain text
file. No fixed lenght. Let's say database.txt is something like
żIs it possible to try an approach based on WHEN statements? I mean:
LOAD DATA
fruits,orange,orange
fruits,banana,yellow
fruits,pear,green
users,John Doe,25,34,26th upper street,0, 12-2-2003
users,Fred Flinstone, 24,5,14th Downing Lane,1,1-7-2002
INFILE database.txt
FIELDS TERMINATED BY ','
WHEN (first field is 'fruits')
(name, color)
WHEN (first field is 'users')
(name, age, visits, address, active, since)
I only whant to know if it is possible or not, but will wellcome advice in ctl file sintax.
Thanks in advance and best regards Received on Wed Feb 25 2004 - 19:04:21 CET