How to create DataStage Routines?

A_SUSHMA · Post by **A_SUSHMA** » Mon Mar 31, 2014 12:29 am

Hi All,

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

Could you please guide me ?

IBM Analytics Champion 2009 - 2020 · Post by **asorrell** » Mon Mar 31, 2014 9:06 am

This is a very broad topic. Are you a C programmer already? What are you trying to accomplish?

chulett · Post by **chulett** » Mon Mar 31, 2014 9:32 am

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

chulett · Post by **chulett** » Tue Apr 01, 2014 10:28 am

Regardless, this would be a good place to start.

A_SUSHMA · Post by **A_SUSHMA** » Tue Apr 01, 2014 11:27 pm

Thank you Chulett...

Can I get sample routines in any site?

ray.wurlod · Post by **ray.wurlod** » Tue Apr 01, 2014 11:30 pm

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.

ray.wurlod · Post by **ray.wurlod** » Tue Apr 01, 2014 11:30 pm

You get to create routines on the Advanced DataStage training class from IBM (now offered through its training providers).

kduke · Post by **kduke** » Wed Apr 02, 2014 6:18 pm

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.

A_SUSHMA · Post by **A_SUSHMA** » Thu Apr 03, 2014 6:10 am

Hi,
I tried to search for pxReplace. But, I didn't find exact link. If possible can you share the link...

chulett · Post by **chulett** » Thu Apr 03, 2014 7:26 am

pxEReplace

priyadarshikunal · Post by **priyadarshikunal** » Thu Apr 03, 2014 7:35 am

pxEReplace, was originally written by DSGuru2B if that eases your search.

chulett · Post by **chulett** » Thu Apr 03, 2014 7:55 am

Actually, people posting the correct name of the routine is the greatest search easer.