Modify Stage -- Warning mEssage

pavanvuchili · Post by **pavanvuchili** » Fri Mar 13, 2009 3:19 am

Hi,

I am using modify stage to get the substring of a field. But i getting
repeated warning message. Please find the below.

i am converting Input varchar(5) to output varchar(2).For that i am using substring fucntion in modify stage.

Function: MKTG_CHANNEL_CD: string = substring[1,2] (MKTG_CHANNEL_CD)

Warning message:
Modify_226: When checking operator: When binding output schema variable "outRec": When binding output interface field "MKTG_CHANNEL_CD" to field "MKTG_CHANNEL_CD": Conversion from source type "string[max=5]" to result type "string": Taking substring of variable-length source string.

Please help me on this....

Thanks
pavan

ray.wurlod · Post by **ray.wurlod** » Fri Mar 13, 2009 1:20 pm

Add an additional Specification containing only the word NOWARN.

hcdiss · Post by **hcdiss** » Wed Aug 05, 2009 7:24 am

[quote="ray.wurlod"]Add an additional Specification containing only the word NOWARN. ...[/quote]

Hi Ray,

Where should i add the word 'NOWARN'? ...

will it be like this? -> MKTG_CHANNEL_CD: string = substring[1,2] (MKTG_CHANNEL_CD) NOWARN

datisaq · Post by **datisaq** » Wed Aug 05, 2009 7:52 am

Add an additional entry and give as "NOWARN".

ray.wurlod · Post by **ray.wurlod** » Wed Aug 05, 2009 6:24 pm

Specification = MKTG_CHANNEL_CD: string = substring[0,2] (MKTG_CHANNEL_CD)
Specification = NOWARN