DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
dstager
Participant



Joined: 08 Jan 2008
Posts: 47

Points: 404

Post Posted: Wed May 29, 2019 2:12 am Reply with quote    Back to top    

DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Trying to write source column Varchar(max) to target Varchar(max) in SQL Server. There is error stating mismatch column length/size with truncation of data...

I have tried writing into SQL using LongVarchar (setting array sixe 1) but the error persists. Some incoming rows exceed the 8000 character length, so it's preferred we leave the character length to 'blank'.

Thanks in advance.
UCDI



Group memberships:
Premium Members

Joined: 21 Mar 2016
Posts: 376

Points: 3877

Post Posted: Wed May 29, 2019 9:09 pm Reply with quote    Back to top    

its been a while but if I remember this right, sql server wanted nvarchar not long varchar for long strings. try that?
Rate this response:  
Not yet rated
dstager
Participant



Joined: 08 Jan 2008
Posts: 47

Points: 404

Post Posted: Wed May 29, 2019 9:37 pm Reply with quote    Back to top    

Yes - tried that...actually, that would further restrict the allowable size...
Rate this response:  
Not yet rated
yugee
Participant



Joined: 04 Feb 2011
Posts: 34

Points: 284

Post Posted: Mon Jun 10, 2019 5:45 pm Reply with quote    Back to top    

Try: Set the jobs corresponding column type to LONGVARCHAR to a length of zero along with the Array size property to a value of 1.
Rate this response:  
Not yet rated
dstager
Participant



Joined: 08 Jan 2008
Posts: 47

Points: 404

Post Posted: Thu Jul 18, 2019 10:39 am Reply with quote    Back to top    

After the field is loaded into a Varchar max column...the data seems to be truncated (missing) - no more runtime error...but the data is missing...
Rate this response:  
Not yet rated
ray.wurlod

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Australia Usergroup, Server to Parallel Transition Group

Joined: 23 Oct 2002
Posts: 54535
Location: Sydney, Australia
Points: 295717

Post Posted: Mon Jul 22, 2019 7:09 pm Reply with quote    Back to top    

See my posts elsewhere about MAX_FETCH_BUFF.

_________________
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours