on 02-22-2013 8:48 PM
when i run this in script editor: import from '/dropbox/sidthekid/orders.ctl';
get the following error : processing a fields statement at "enclose"'
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
it worked thanks you can close this thread
Hi Sudarshan,
Can you please copy-paste the content of your ctl file here?
Thanks,
Anooj
import data
into table P1385644140. "ORDERS"
from 'ORDERS.csv'
record delimited by '\n'
fields delimited by ','
optionally enclosed by ""
error log 'orders.err'
Actually the first error was because it was enclose instead of enclosed. After I corrected this is the error: general error: Error processing a fields statement at """"
UPDATE: added single quotes: optionally enclosed by ' "" '
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.