Routine

samba · Post by **samba** » Wed May 17, 2006 6:47 am

Can i call server routine in parallel job, if it is possible how to call routine in before/after job subroutine, its not available under before/after job subroutine, can u please help me regarding this

ArndW · Post by **ArndW** » Wed May 17, 2006 6:56 am

Server routines can be called in parallel jobs:

a) in the job Before/After
b) from BASIC transform stages

samba · Post by **samba** » Wed May 17, 2006 6:58 am

what are Basic transformation can u explain me

balajisr · Post by **balajisr** » Wed May 17, 2006 7:34 am

Basic transformer is a stage in PX just like any other stages like copy,modify.. It is similar in functionality to server edition transfomer. You can call server routines in px just the way you call the server routine in server edition.Please read chapter 17 in parallel job developer guide for more information as to how to use the stage.

Roopanwita · Post by **Roopanwita** » Mon Jan 07, 2008 1:03 am

Can we call it in normal Transformer?As in my pallate I am not able to see Basic Transformer(Parallel Extender 7.5.1) and in my source data one date column is coming as '1-Jan-2000',(Source is sequential File) and I need to convert it into dd/mm/yyyy format .I wrote a server routine for converson,but I am unable to call this routine in Transformer.

Roopanwita · Post by **Roopanwita** » Mon Jan 07, 2008 1:05 am

Can we call it in normal Transformer?As in my pallate I am not able to see Basic Transformer(Parallel Extender 7.5.1) and in my source data one date column is coming as '1-Jan-2000',(Source is sequential File) and I need to convert it into dd/mm/yyyy format .I wrote a server routine for converson,but I am unable to call this routine in Transformer.

ray.wurlod · Post by **ray.wurlod** » Mon Jan 07, 2008 1:37 am

It's preferable to use parallel functions rather than server routines in parallel jobs. Your transformation can be readily achieved using DateToString() nested inside StringToDate() if the source and target data types are date or the reverse nesting if the data types are string.

BASIC Transformer stage can be found in the Stage Types branch of the Repository. That it is not in the Palette is deliberate (though you can customize your Palette) because they would prefer that you don't use it.

Stop using a server job mindset when creating parallel jobs.

chulett · Post by **chulett** » Mon Jan 07, 2008 7:40 am

balajisr wrote:Basic transformer is a stage in PX just like any other stages like copy,modify.. It is similar in functionality to server edition transfomer. You can call server routines in px just the way you call the server routine in server edition.Please read chapter 17 in parallel job developer guide for more information as to how to use the stage.

And then avoid using them if at all possible. Think Parallel not Server - and as Ray notes, there's a reason it's not on the pallete by default.