ControlFile, Syntax help needed

From: Jerra <jerra_at_consilia.aland.fi>
Date: Wed, 12 May 1999 15:55:27 +0300
Message-ID: <37397A3E.3D72A2B5@consilia.aland.fi>

I want to load into multible tables, the data is included in the controlfile. Is it possible to have a structure similar to this with each table's data inserted after the declaration???

Load Data
Infile *
DiscardMax 999
Append Into Table Table1
Fields Terminated By "|" Optionally Enclosed By '"'
(Field1.....)

BeginData
"blabla....."

Append Into Table Table2
Fields Terminated By "|" Optionally Enclosed By '"'
(Field1......)

BeginData
"blabla......."

Regards
/Jerra Received on Wed May 12 1999 - 07:55:27 CDT