Solved

Sqlloader terminate with TAB errors in ver 8.1.5.0.0

Posted on 2001-08-23
1
855 Views
Last Modified: 2012-06-21
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
Comment
Question by:seeyou
1 Comment
 
LVL 2

Accepted Solution

by:
AllaI earned 50 total points
ID: 6420371
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

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…

808 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question