About modify stage

Nripendra Chand · Post by **Nripendra Chand** » Thu Sep 15, 2005 5:56 am

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

richdhan · Post by **richdhan** » Thu Sep 15, 2005 6:12 am

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

ray.wurlod · Post by **ray.wurlod** » Thu Sep 15, 2005 3:57 pm

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.

kumar_s · Post by **kumar_s** » Thu Sep 15, 2005 10:37 pm

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

Nripendra Chand · Post by **Nripendra Chand** » Thu Sep 15, 2005 11:03 pm

I also counldn't find "Orchestrate Operators Guide ". Please tell where can i find it.

Regards,
Nripendra

ray.wurlod · Post by **ray.wurlod** » Fri Sep 16, 2005 12:21 am

It's downloadable from ADN - you can find a link to the Orchestrate manuals by searching here at DSX.

apraman · Post by **apraman** » Fri Sep 16, 2005 2:29 am

Oh Lord, Getting registered in ADN is one of most difficult task.
Is there any other source to get "Orchestrate Operators Guide " ?

ray.wurlod · Post by **ray.wurlod** » Fri Sep 16, 2005 3:51 am

You get the Orchestrate manuals when you attend a DS314PX class (DataStage Essentials - Enterprise Edition).

kumar_s · Post by **kumar_s** » Fri Sep 16, 2005 8:48 am

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

ray.wurlod · Post by **ray.wurlod** » Fri Sep 16, 2005 4:01 pm

Had you searched here, as advised, you would have found this URL

kumar_s · Post by **kumar_s** » Sat Sep 17, 2005 4:45 am

Hi ray,
I could find now, thats beautiful!!!
I dont know why i couldnt find it in previous search.

regards
kumar

srikanthd1978 · Post by **srikanthd1978** » Tue Sep 20, 2005 9:44 am

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...

DSXchange

About modify stage

About modify stage

Re: About modify stage