DSXchange

can we use routines in PX?

I'm tempted to just say "yes", however... write or use? And of what routines do you speak of?

i mean can we use DS basic routines in PX or we need to write them in C++
not sure so wish to know.....

if yes...

Same routine which is used in server can be used in PX?

Yes, Server BASIC routines can be used in a PX "BASIC Transformer" with all of the caveats they bring to the table. Or, better yet, write them in C++.

Before/after job subroutines in parallel jobs are written in DataStage BASIC.

Routines callable from parallel Transformer stage must be written in C++ and compiled and linked, and have an entry in the Routines part of the Repository (a parallel "routine" is actually a description of the location of and arguments for the actual external object).

Routines callable from a BASIC Transformer stage are written in DataStage BASIC and may be the same ones that are used in server jobs.

So aftter writting routine in C++ we need to copy it into the same DS compiler...
Also....Is there any need atall to routines......

I detect some misunderstanding of how C (or C++) programming works. You don't "copy into a compiler". You use a compiler to convert your source code into something executable, and you use a linker to add references to any other libraries/objects that your code needs.

To use such a routine from a parallel Transformer stage, you need to create a "parallel routine definition" in the Repository. This is not the routine itself, but a piece of metadata that describes the location of the routine and the arguments (and their data types) that it requires.