Re: SQL*Loader - No End Of Record Markers

From: Paweł Plichta <Pawel_Plichta_at_netia.pl>
Date: Thu, 16 Jul 1998 10:49:42 +0200
Message-ID: <6okep6$o4d$1@info.nask.pl>

Hi,
If you use in control file (name.CTL) word "FIX nn", end of record (line) markers is not necessary. (nn- record length must be constant)

Examples
LOAD DATA
INFILE "source data" "FIX 80"
INSERT
INTO TABLE TableName

(Column1            POSITION( 1: 7) CHAR
, Column2           POSITION( 8: 8) CHAR

...)
Pawel

fcs343_at_my-dejanews.com napisał(a) w wiadomości: <6ok5gd$e46$1_at_nnrp1.dejanews.com>...
>Hi
>
>I need some help with using SQL*Loader.
>
>I need to load a fixed record file with no end of record (line) markers.
>
>
>Francis Sieberhagen
>
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
Received on Thu Jul 16 1998 - 03:49:42 CDT