Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.
Moderators: chulett , rschirm , roy
pavanvuchili
Participant
Posts: 5 Joined: Tue Apr 01, 2008 4:41 am
Location: India
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
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Post
by ray.wurlod » Fri Mar 13, 2009 1:20 pm
Add an additional Specification containing only the word NOWARN.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
hcdiss
Participant
Posts: 26 Joined: Sat Oct 14, 2006 1:45 am
Location: Boston
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
hcdiss
datisaq
Participant
Posts: 154 Joined: Wed May 14, 2008 4:34 am
Post
by datisaq » Wed Aug 05, 2009 7:52 am
Add an additional entry and give as "NOWARN".
IBM Certified - Information Server 8.1
ray.wurlod
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Post
by ray.wurlod » Wed Aug 05, 2009 6:24 pm
Specification = MKTG_CHANNEL_CD: string = substring[0,2] (MKTG_CHANNEL_CD)
Specification = NOWARN
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.