seeyou
asked on
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.tx t'
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"
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.tx
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"
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.