Re: sql*loader...
Date: Mon, 27 Dec 1999 15:56:09 GMT
Message-ID: <38698bbd.4060298_at_super.news-ituk.to>
Try this example from Oracle's demos as a guide:
- Copyright (c) 1991 by Oracle Corporation
-- NAME
- ulcase5.ctl - <one-line expansion of the name>
- DESCRIPTION
- <short description of component this file declares/defines>
- RETURNS
--
- NOTES
- <other useful comments, qualifications, etc.>
- MODIFIED (MM/DD/YY)
- ksudarsh 04/08/94 - merge changes from branch 1.3.710.1
- ksudarsh 02/21/94 - quote dat file
- ksudarsh 03/11/93 - make filename lowercase
- ksudarsh 11/06/92 - infile is ulcase5
- cheigham 08/28/91 - Creation
--
- $Header: ulcase5.ctl,v 1.4 1994/04/08 13:44:31 ksudarsh Exp $ case5.ctl
--
- Loads EMP records from first 23 characters
- Creates and loads PROJ records for each PROJO listed
- for each employee
LOAD DATA
INFILE 'ulcase5.dat'
BADFILE 'ulcase5.bad'
DISCARDFILE 'ulcase5.dis'
REPLACE
INTO TABLE EMP
(EMPNO POSITION(1:4) INTEGER EXTERNAL, ENAME POSITION(6:15) CHAR, DEPTNO POSITION(17:18) CHAR, MGR POSITION(20:23) INTEGER EXTERNAL)
INTO TABLE PROJ
-- PROJ has two columns, both not null: EMPNO and PROJNO
WHEN PROJNO != ' '
(EMPNO POSITION(1:4) INTEGER EXTERNAL,
PROJNO POSITION(25:27) INTEGER EXTERNAL) -- 1st proj
INTO TABLE PROJ
WHEN PROJNO != ' '
(EMPNO POSITION(1:4) INTEGER EXTERNAL,
PROJNO POSITION(29:31) INTEGER EXTERNAL) -- 2nd proj
INTO TABLE PROJ
WHEN PROJNO != ' '
(EMPNO POSITION(1:4) INTEGER EXTERNAL,
PROJNO POSITION(33:35) INTEGER EXTERNAL) -- 3rd proj
You will need to have some test to determine which table gets the data...
Ratna Kumar <rkumar13_at_ford.com> wrote:
>Is there a way to load two files "a.dat" and "b.dat" into tables A and >B RESPECTIVELY , using same control file . >The WHEN condition was not suitable to seperate the Loading of files. > >Thanks, >Ratna -----------== Posted via Newsfeeds.Com, Uncensored Usenet News ==---------- http://www.newsfeeds.com The Largest Usenet Servers in the World!
------== Over 73,000 Newsgroups - Including Dedicated Binaries Servers ==-----
Received on Mon Dec 27 1999 - 16:56:09 CET