DSXchange

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

Add an additional Specification containing only the word NOWARN.

[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

Add an additional entry and give as "NOWARN".

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