sql loader question

  • From: "ed lewis" <eglewis@xxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 16 Mar 2004 18:18:13 -0500

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
 )

Other related posts: