Page 1 of 1

How to create DataStage Routines?

Posted: Mon Mar 31, 2014 12:29 am
by A_SUSHMA
Hi All,

How do I create Routines in DataStage? Previously I haven't created any DataStage routines..

Could you please guide me ?

Posted: Mon Mar 31, 2014 9:06 am
by asorrell
This is a very broad topic. Are you a C programmer already? What are you trying to accomplish?

Posted: Mon Mar 31, 2014 9:32 am
by chulett
C++ routines for use in a PX job? BASIC routines for use in a Sequence or Server job or as a Before/After job subroutine or in Job Control? As noted, you might want to narrow this down a bit...

Posted: Tue Apr 01, 2014 10:28 am
by chulett

Posted: Tue Apr 01, 2014 11:27 pm
by A_SUSHMA
Thank you Chulett...

Can I get sample routines in any site?

Posted: Tue Apr 01, 2014 11:30 pm
by ray.wurlod
Here is probably as good as any. A search for "parallel routine" will throw up a few, but you'll have to filter for those that actually contain code.

You might try a search for "pxReplace" but that code's perhaps a little too detailed for a beginner.

Posted: Tue Apr 01, 2014 11:30 pm
by ray.wurlod
You get to create routines on the Advanced DataStage training class from IBM (now offered through its training providers).

Posted: Wed Apr 02, 2014 6:18 pm
by kduke
Do a search for pxReplace. Lots of tips on how to do this. Plust the code is posted so you can test it. BASIC routines are in the SDK. Look at those and see if you can figure them out.

Posted: Thu Apr 03, 2014 6:10 am
by A_SUSHMA
Hi,
I tried to search for pxReplace. But, I didn't find exact link. If possible can you share the link...

Posted: Thu Apr 03, 2014 7:26 am
by chulett
pxEReplace

Posted: Thu Apr 03, 2014 7:35 am
by priyadarshikunal
pxEReplace, was originally written by DSGuru2B if that eases your search.

Posted: Thu Apr 03, 2014 7:55 am
by chulett
Actually, people posting the correct name of the routine is the greatest search easer. :wink: