Re: SQL*Loader

From: Vorname Name <Vorname.Name_at_pcm.bosch.de>
Date: Thu, 1 Apr 1999 13:49:24 +0200
Message-ID: <7dvmh7$dak$1@news.fr.internet.bosch.de>

Hi Mark,
I use the following loader syntax:

• Loader-for data xyz LOAD DATA INFILE 'd:\ftp\input\xxx.dat' INTO TABLE xyz.xxx replace FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' (field1 position (01:08) date 'DDMMYYYY', filed2 position (11:20) char, field3 position (43:50) integer external, filed4 position (57:62) char)

you may start this loader session with a batch file:

rem loading the data into an ORACLE DB. sqlldr80 user/password direct=true control=d:\ftp\progs\controlfile.ctl log=d:\ftp\progs\logfile.log

controlfile.ctl is the file with the laoder statements the log file contains the messages of the loader session.

My question is:
Does anybody know a way to get the control-file statements in an easier way. I have a record with boring 1200 byte!! The source of this file is a SAP-R/3 system which creates this file with an ABAP.

Mit freundlichen Grüßen / Kind Regards

Klaus Hagspihl

---

QI/LBS1-Bh, Tel.: 08323/20-4584 Fax.: 08323/20-14584 EMail: Klaus.Hagspihl_at_de.bosch.com
SCT DWH: http://www.intranet.bosch.de/Qi/sctdwh

Mark Gumbs <mgumbs_at_hotmail.com> schrieb in im Newsbeitrag: <37034776.0_at_145.227.194.253>...
> Hi
>
> Does anyone know how to specify the rows you want imported into a table?
> For example, i have a CSV file of 10 fields and a table with 5 fields. I
> want to specify which fields i want from the CSV into the table.
>
> Mark
>
>

Mark Gumbs <mgumbs_at_hotmail.com> schrieb in im Newsbeitrag: 37034776.0_at_145.227.194.253...
> Hi
>
> Does anyone know how to specify the rows you want imported into a table?
> For example, i have a CSV file of 10 fields and a table with 5 fields. I
> want to specify which fields i want from the CSV into the table.
>
> Mark
>
>
Received on Thu Apr 01 1999 - 05:49:24 CST