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



Joined: 16 Mar 2017
Posts: 1
Location: Perth
Points: 15

Post Posted: Thu Mar 16, 2017 1:03 am Reply with quote    Back to top    

DataStage® Release: 11x
Job Type: Parallel
OS: Windows
Additional info: set ustringmax for avi stage
I'm running a QualityStage AVI job across some addresses and finding that the output address has the Building_QSAV data truncated at 30 characters even though the output column for Building_QSAV is set to length of 50.

The default setting for the column has UNICODE set so when I change this to <BLANK> and re-run I get a warning in the job log:

AVI: When checking operator: On output data set 0: When binding output interface field "Building_QSAV" to field "Building_QSAV": Implicit conversion from source type "ustring[max=30]" to result type "string[max=50]": Converting ustring to string using codepage ASCL_MS1252.

This leads me to believe that the AVI stage has some internal column length of 30 set when generating the QSAV data and it automatically truncates any BUILDING output generated above 30 characters.

So... is there a way to set this internal 30 character limit any higher?

Cheers Danny
rjdickson
Participant



Joined: 16 Jun 2003
Posts: 377
Location: Chicago, USA
Points: 2528

Post Posted: Thu Mar 16, 2017 5:47 am Reply with quote    Back to top    

Hi Danny,

It sounds like a PMR is needed. Please include as many examples as you can of the truncation to help IBM isolate and resolve the issue.

_________________
Regards,
Robert
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