Re: SQL Ldr Control File Question

Tim -

A few thoughts come to mind:

1. Delimit the input file with double quotes instead of single quotes. I haven't tried this, but it should work.

INFILE "C:\TIM'SF~1\ACCESS~1\SPACEB~1\NEW\ROOM_N~1.TXT" 2. Put the actual data in with the control file and specify:

infile *

3. Map a new drive to your existing directory and refer to it:

infile 'z:\room_n~1.txt'

4. Don't use a single quote in a directory name!

Bye,
TG

Tim Marshall wrote:

> I've stumbled across a bit of a problem in that the control file I've
> created for sqlldr80 has a single quote in it, ie:
>
> LOAD DATA
> INFILE 'C:\TIM'SF~1\ACCESS~1\SPACEB~1\NEW\ROOM_N~1.TXT'
> APPEND INTO TABLE TEMP_TIM_AREA FIELDS TERMINATED X '09'
> (TMA_AREA, TMA_AREA_SQ_FT)
>
> You'll see that the INFILE text file specification has a main directory
> with a ' in it.
>
> Can anyone suggest how best to deal with this, other than renaming the
> main directory?
>
> Thanks very much in advance.
> --
> Tim - http://www.ucs.mun.ca/~tmarshal/
> ^o<
> /#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
> /^^ "Want some?" - Ditto
Received on Mon Dec 16 2002 - 18:51:38 CST