Sqlloader question
From: thierry merlin <t.merlin_at_citb.bull.net>
Date: 1998/01/22
Message-ID: <01bd2746$ba6de480$3c4c5ac0_at_thierry.citb.bull.net>#1/1
Date: 1998/01/22
Message-ID: <01bd2746$ba6de480$3c4c5ac0_at_thierry.citb.bull.net>#1/1
Hi,
[Quoted] [Quoted] 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)
[Quoted] Thank's for your help. Received on Thu Jan 22 1998 - 00:00:00 CET