Sqlloader question

Hi,

With one file ( file.data), I want to insert in two table at the same time. Can I write this in my control file (file.ctl) : Load Data
INFILE file.data
APPEND INTO TABLE table1
(CP_CP position(1:3) char,

 CP_TOWN position( 10,15) char,
 CO_CODE) INTO TABLE table2
( NAME position (4:9) char)

Thank's for your help. Received on Thu Jan 22 1998 - 00:00:00 CST