AVI stage - how to change internal column length ustringmax

Infosphere's Quality Product

Moderators: chulett, rschirm

Post Reply
NeoDan
Participant
Posts: 1
Joined: Thu Mar 16, 2017 12:22 am
Location: Perth

AVI stage - how to change internal column length ustringmax

Post by NeoDan »

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
Posts: 378
Joined: Mon Jun 16, 2003 5:28 am
Location: Chicago, USA
Contact:

Post by rjdickson »

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
Post Reply