About modify stage
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 196
- Joined: Tue Nov 23, 2004 11:50 pm
- Location: Sydney (Australia)
About modify stage
Hi,
I'm trying to use the modify stage for reformatting one col. I gave following derivation as the specification in the modify stage:
CRSLT_LEAD_REC=left(LnkForLkup1.CRSLT_LEAD_REC,4):"-":right(LnkForLkup1.CRSLT_LEAD_REC,2)
it is compiling successfully, but during run it's giving following error:
main_program: Error parsing modify adapter: Error in binding: Unknown conversion: left; input:
CRSLT_LEAD_REC=left(LnkForLkup1.CRSLT_LEAD_REC,4):"-":right(LnkForLkup1.CRSLT_LEAD_REC,2)
Please give your inputs if someone has any clue..
Regards,
Nripendra
I'm trying to use the modify stage for reformatting one col. I gave following derivation as the specification in the modify stage:
CRSLT_LEAD_REC=left(LnkForLkup1.CRSLT_LEAD_REC,4):"-":right(LnkForLkup1.CRSLT_LEAD_REC,2)
it is compiling successfully, but during run it's giving following error:
main_program: Error parsing modify adapter: Error in binding: Unknown conversion: left; input:
CRSLT_LEAD_REC=left(LnkForLkup1.CRSLT_LEAD_REC,4):"-":right(LnkForLkup1.CRSLT_LEAD_REC,2)
Please give your inputs if someone has any clue..
Regards,
Nripendra
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Beware, too, that there are some errors in the Parallel Job Developer's Guide - some functions are described there that do not actually exist for the Modify stage. The preferred reference at the moment is the Orchestrate Operators Guide.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Hi,ray.wurlod wrote:Beware, too, that there are some errors in the Parallel Job Developer's Guide - some functions are described there that do not actually exist for the Modify stage. The preferred reference at the moment is the Orchestrate Operators Guide.
Where can i find Orchestrate Operators Guide
regards
kumar
-
- Premium Member
- Posts: 196
- Joined: Tue Nov 23, 2004 11:50 pm
- Location: Sydney (Australia)
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
It's downloadable from ADN - you can find a link to the Orchestrate manuals by searching here at DSX.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Had you searched here, as advised, you would have found this URL
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Charter Member
- Posts: 38
- Joined: Wed Mar 17, 2004 1:16 am
- Location: USA
Re: About modify stage
Nripendra Chand wrote:Hi,
I'm trying to use the modify stage for reformatting one col. I gave following derivation as the specification in the modify stage:
CRSLT_LEAD_REC=left(LnkForLkup1.CRSLT_LEAD_REC,4):"-":right(LnkForLkup1.CRSLT_LEAD_REC,2)
it is compiling successfully, but during run it's giving following error:
main_program: Error parsing modify adapter: Error in binding: Unknown conversion: left; input:
CRSLT_LEAD_REC=left(LnkForLkup1.CRSLT_LEAD_REC,4):"-":right(LnkForLkup1.CRSLT_LEAD_REC,2)
Please give your inputs if someone has any clue..
Regards,
Nripendra
I see that u r trying to Concatenate two substring values..u can do the substring functionality in the mdfy operator but the concatenation with the "-" char needs to be done using a xfm....and if u had decided to go for a xfm..u might as well do the substring and the concat there..and remove the overhead of mdfy op..this is one way to look at this..maybe there r better ways...