Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 895
  • Last Modified:

Sqlloader terminate with TAB errors in ver 8.1.5.0.0

The following CTL script runs OK on version sqlloader 8.0.5.0.0
When I run it on version sqlloader 8.1.5.0.0 I am getting errors :

Record 2: Rejected - Error on table STG_RECIPE, column FORMULA_NAME.
no terminator found after TERMINATED and ENCLOSED field
Record 3: Rejected - Error on table STG_RECIPE, column FORMULA_NAME.
no terminator found after TERMINATED and ENCLOSED field


The terminated by in the CTL file is a TAB ( keyboard tab key ).  I have tried replacing the TAB with X'09' but still get the same error.

<-- CTL file -->
LOAD DATA
INFILE  'c:\fps\Inbound\recipes.txt'
BADFILE 'c:\fps\recipes.bad'
TRUNCATE
INTO TABLE STG_RECIPE
WHEN  (FORMULA_NAME <> 'FORMULA NAME')
FIELDS TERMINATED BY '     ' OPTIONALLY ENCLOSED BY '"'
(FORMULA_NAME,
 PRODUCT,
 STD_FORM_QTY,
 INGREDIENT,
 ITEM_NUMBER,
 QTY_PER_BATCH,
 UOM,
 LAST_UPDATE)

<-- Sample Data: fields are seperated by TAB, some fields are delimited by " -->
"00025G-A02          "     "00025G            "        1600.00     "00416             "        60          90.83     "KG"     "10-JUN-2000 10:19:37.10"
"00025G-A02          "     "00025G            "        1600.00     "00501             "        50          18.25     "KG"     "10-JUN-2000 10:19:37.10"
"00025G-A02          "     "00025G            "        1600.00     "00576             "        20           4.20     "KG"     "10-JUN-2000 10:19:37.10"
"00025G-A02          "     "00025G            "        1600.00     "00595             "        10        1479.02     "KG"     "10-JUN-2000 10:19:37.10"

0
seeyou
Asked:
seeyou
1 Solution
 
AllaICommented:
I've heard about a problem  with FIELDS TERMINATED BY <tab>  OPTIONALLY ENCLOSED BY <something> in 8.1.  The only way I know is to get rid of  OPTIONALLY ENCLOSED BY clause by trimmimg off the double qoutes while loading:
LOAD DATA
   INFILE ...
   INTO TABLE T1
   FIELDS TERMINATED BY X'9'
   ( FORMULE_NAME   "trim( chr(34) from :formula_name )",
     ....    
   )

0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now