Help in building a simple parallel routine

[vskr72]

I need to build a simple routine to handle a logic like this. I went thru the option of creating a enw parallel routine. But, I am lost as to where I need to put this logic. There doesnt seem to be a place to add this code.

Code: Select all

If IsValid('date', ToTfm.AS_OF_DATE,"%yyyy%mm%dd") then StringTODate(ToTfm.AS_OF_DATE,"%yyyy%mm%dd") else SetNull()

Am I missing anything here. Can any one send me some instructions for it? Thank y ou.

[ray.wurlod]

You create and compile the routine external to DataStage. Preferably you also create and compile a main program with which to test it.

The "parallel routine" that you create within DataStage is not actually a routine - it is an interlude - a record of the existence, location and arguments of the actual routine executable.

[chulett]

Also understand that a parallel routine must be written in C++.

[zulfi123786]

Code: Select all

If IsValid('date', ToTfm.AS_OF_DATE,"%yyyy%mm%dd") then StringTODate(ToTfm.AS_OF_DATE,"%yyyy%mm%dd") else SetNull()

1. IsValid() in parallel doesnt take third argument !
2. Date is not a native data type for C
3. SetNull() which is an outband Null cant be passed to and from a parallel routine
4. The very simple single line statement of datastage would become bulky when you involve pointers for storing the arguments.