| field length issue [message #72050] |
Wed, 26 February 2003 19:43  |
ram
Messages: 95
Registered: November 2000
|
Member |
|
|
Hello,
I am trying to load data using the following ctl file
load data
infile 'description_test.txt'
badfile 'description_test.bad'
discardfile 'description_test.dsc'
insert
into table description_test
fields terminated by ',' optionally enclosed by '"'
(
item_id,
description
)
Description filed is 4000 C long
In my sample data, my description filed is less than 1000 characters, but still the loader is rejecting the records (Exceeds maximum length)
I generated the text file from an original excel file and the description text has many special characters.
I am able to update the table directly using sql navigator
Thank you for your help in advance
Ram
|
|
|
|
|
|
| Re: field length issue [message #72059 is a reply to message #72055] |
Thu, 27 February 2003 11:13  |
ram
Messages: 95
Registered: November 2000
|
Member |
|
|
Hello Mahesh,
My description filed can be 2000 char long
should my ctl be ..
insert into table mytablefields terminated by ',' optionally enclosed by '"' (item_id,description char "substr(:description,1,2000)")
Thank you in advance
Ram
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
