Re: SQL*Loader

I think you just gave an answer to the wrong question :)

Mark

Vorname Name wrote in message <7dvmh7$dak$1_at_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 - 08:09:48 CST