Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 909
  • 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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