Re: SQL*LOADER newline problem

sslee wrote:
>
> For example.
>
> LOAD DATA
> INFILE *
> INTO TABLE DEPT
> FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
> (DEPTNO, DNAME, LOC)
> BEGINDATA
> 12,RESEARCH,"SARA <-- Column including newline
> TOGA"
> 10,"ACCOUNTING",CLEVELAND
> 11,"ART",SALEM
> 13,FINANCE,"BOSTON"
> 21,"SALES",PHILA.
> 22,"SALES",ROCHESTER
> 42,"INT'L","SAN FRAN"
>
> I must insert rows which have columns including newlines.
> How to insert newline in SQL*LOADER?
>
> help me!!! :)

The Oracle 7.3.3 SQL*Loader ULCASE4.CTL example shows a method based on having an asterisk (*) in the first column of a continuation record. Perhaps you can do something similar:

LOAD DATA
INFILE "ulcase4.dat"
DISCARDFILE "ulcase4.dis"
DISCARDMAX 999
REPLACE
CONTINUEIF (1) = '*'
INTO TABLE EMP

( EMPNO    POSITION(01:04) INTEGER EXTERNAL,
  ENAME    POSITION(06:15) CHAR,
  JOB      POSITION(17:25) CHAR,
  MGR      POSITION(27:30) INTEGER EXTERNAL,
  SAL      POSITION(32:39) DECIMAL EXTERNAL,
...

Yours,  

Geoff Houck
systems hk
hksys_at_teleport.com
http://www.teleport.com/~hksys Received on Fri Jul 31 1998 - 23:05:57 CEST