SQL Ldr Control File Question

From: Tim Marshall <Sabot_at_Spam.On>
Date: Mon, 16 Dec 2002 19:07:13 -0330
Message-ID: <3DFE5599.25278B8A@Spam.On>

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 - 16:37:13 CST