Home » Other » General » sqlldr question
sqlldr question [message #103414] Thu, 28 August 2003 16:00 Go to next message
ka
Messages: 1
Registered: August 2003
Junior Member
1. I am using a variable-length control file delimited by
2. A column in database is a varchar(25).This field represents 40th column in database (total 50 columns).
3. In case my datafile has data for this column exceeding length of 25, I want the sqlloader to take the first 25 characters and load them into the database, instead of rejecting the record complaining 'exceeded the length'.

I tried in my ctl: column_name position(*:*+22) which did not work.

Thanks
kap
Re: sqlldr question [message #103420 is a reply to message #103414] Thu, 04 September 2003 08:28 Go to previous messageGo to next message
jelmer
Messages: 3
Registered: September 2003
Junior Member
Hello Kap

you can try this:

column_40 "substr (:column_40, 1, 25)",

instead of

column_40,

Jelmer
Re: sqlldr question [message #103466 is a reply to message #103414] Mon, 20 October 2003 04:20 Go to previous message
Shriyans Jain
Messages: 2
Registered: October 2003
Junior Member
Why do not use substr(...,1,25) FUNCTION TO GET FIRST 25 CHARACTER.
Previous Topic: Bar Code Printing in character mode reports
Next Topic: Buffer Sort
Goto Forum:
  


Current Time: Thu Dec 01 16:37:22 CST 2022