Server routine in a parallel job with a Basic transformer?
Moderators: chulett, rschirm, roy
Server routine in a parallel job with a Basic transformer?
Hi,
I am using a Basic transformer in a parallel job, can I use a server routine in that transformer ?. I am trying to do it and is is not working.
thanks
I am using a Basic transformer in a parallel job, can I use a server routine in that transformer ?. I am trying to do it and is is not working.
thanks
Ans = ""
FOR I = 1 to LEN (InputString)
ASCIICode = Seq(InputString[I,1])
IF ASCIICode >= 32 AND ASCIICode <= 122 AND ASCIICode <> 91 AND ASCIICode <> 93 AND ASCIICode <> 94 THEN Ans = Ans : InputString[I,1]
NEXT I
Thats the code for the routine, I need to get this routine working in the basic transformer or write it as a derivation for a column.
Can anyone help me do it ?
FOR I = 1 to LEN (InputString)
ASCIICode = Seq(InputString[I,1])
IF ASCIICode >= 32 AND ASCIICode <= 122 AND ASCIICode <> 91 AND ASCIICode <> 93 AND ASCIICode <> 94 THEN Ans = Ans : InputString[I,1]
NEXT I
Thats the code for the routine, I need to get this routine working in the basic transformer or write it as a derivation for a column.
Can anyone help me do it ?
<img src="http://img15.imgspot.com/u/07/59/19/unt ... 794506.JPG">
Thats the test output for the routine
Thats the test output for the routine
@ DSguru
The same column from the same source is been used in a server job and the routine works for it. i am comparing my parallel output with that server output to check if the routine is working.
My datatype is char, and yes i am trimming the values.
@ SUD
How can i find out if i am on a SMP system ?
Can i duplicate that routine functionality as a derivation ??
Thanx guys..
The same column from the same source is been used in a server job and the routine works for it. i am comparing my parallel output with that server output to check if the routine is working.
My datatype is char, and yes i am trimming the values.
@ SUD
How can i find out if i am on a SMP system ?
Can i duplicate that routine functionality as a derivation ??
Thanx guys..
It should work but right now we are just shooting in the dark. Lets see which arrow hits bullseye. From a glance, nothing seems wrong with the routine and it should work in a px job just as it works in a server job. Write a px routine for it. I remember posting a routine that works with ascii numbers. You should be able to tweak it.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.