sql loader question

From: ed lewis <eglewis_at_hotmail.com>
Date: Tue, 16 Mar 2004 18:18:13 -0500
Message-ID: <BAY13-DAV17sutplhR100031686@hotmail.com>

Hi,

I have a file that I'm attempting
to load into a table with sql loader
using the following ctl file.
On the "ah_descript" column I receive the following error on some of the records :

no terminator found after TERMINATED and ENCLOSED field

The column contains a " (double quote) used to designate inches, such as 6", which I think sql loader is choking on. Is there a way I can handle this within sql loader ?

thanks very much.

OPTIONS (SKIP=1)
LOAD DATA
infile 'csv/12292003-AHPOLNTMP.csv'
INTO TABLE sdusr3.ahpolntmp
fields terminated by ',' optionally enclosed by '"' trailing nullcols

(   AHDATE      DATE 'MM/DD/YYYY',
    AHTIME      char ,
    PO_NUMBER CHAR,

PO_LAWSON CHAR,
LINE_NBR char,

    COST_OPTION   CHAR,
    AH_DESCRIPT   CHAR,
    DISTRIBFLAG   CHAR,

EARLY_DL_DATE DATE 'MM/DD/YYYY',

    ENT_BUY_UOM   CHAR,
    ENT_UNIT_CST  char,
    ERRORCODE     char,
    ERRORMSG      CHAR,
    GLOBALITEMID  CHAR,
    ITEM          CHAR,
    ITEM_TYPE     CHAR,
    MANUF_NBR     CHAR,
    PURCHCLASS    CHAR,
    QUANTITY      char,
    REQUESTERID   CHAR,
    VEN_ITEM      CHAR,
    CUSTOM1     CHAR,
    CUSTOM2     CHAR,
    CUSTOM3     CHAR

)

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

Received on Tue Mar 16 2004 - 17:14:49 CST