Page 1 of 1
About modify stage
Posted: Thu Sep 15, 2005 5:56 am
by Nripendra Chand
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
Posted: Thu Sep 15, 2005 6:12 am
by richdhan
Hi Nripendra Chand,
The Modify stage uses orchestrate functions. It will not accept string functions used in the transformer. Pls make sure what functions are available in the orchestrate manual for these kind of operations.
Moreover, you cannot apply two functions in the derivation.
HTH
--Rich
Posted: Thu Sep 15, 2005 3:57 pm
by ray.wurlod
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.
Posted: Thu Sep 15, 2005 10:37 pm
by kumar_s
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.
Hi,
Where can i find
Orchestrate Operators Guide 
regards
kumar
Posted: Thu Sep 15, 2005 11:03 pm
by Nripendra Chand
I also counldn't find "Orchestrate Operators Guide ". Please tell where can i find it.
Regards,
Nripendra
Posted: Fri Sep 16, 2005 12:21 am
by ray.wurlod
It's downloadable from
ADN - you can find a link to the Orchestrate manuals by searching here at DSX.
Posted: Fri Sep 16, 2005 2:29 am
by apraman
Oh Lord, Getting registered in ADN is one of most difficult task.
Is there any other source to get "Orchestrate Operators Guide " ?
Posted: Fri Sep 16, 2005 3:51 am
by ray.wurlod
You get the Orchestrate manuals when you attend a DS314PX class (DataStage Essentials - Enterprise Edition).
Posted: Fri Sep 16, 2005 8:48 am
by kumar_s
sorrry a DSX search in ADN leads me to forum, i could not find it.
Can you post exact link pls.........
BTW what else been provided in training class
....
regards
kumar
Posted: Fri Sep 16, 2005 4:01 pm
by ray.wurlod
Had you searched here, as advised, you would have found
this URL
Posted: Sat Sep 17, 2005 4:45 am
by kumar_s
Hi ray,
I could find now, thats beautiful!!!
I dont know why i couldnt find it in previous search.
regards
kumar
Re: About modify stage
Posted: Tue Sep 20, 2005 9:44 am
by srikanthd1978
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...