Server routine in a parallel job with a Basic transformer?

[ady]

I got the source as varchar, trimmed and specified the routine and i specified the output format as "CHAR". This did not work.

Could there be any other problem?... plz help

[DSguru2B]

Ok. Lets take a step back. Build a simple routine and call it from within a basic transformer in a px job.

Code: Select all

Ans = EREPLACE(Arg1, "AAA", "xxx")

Build a text file with a few records that have AAA at different places. Run the px job. See if all instances of 'AAA' get replaced with 'xxx'

[ady]

@DSguru

I created a routine like u said and it works in a PX job... I really dont understand why the original dosent work ??

DSguru , you said that you posted a routine dealing with ascii values ..... can you point me to it ?

[DSguru2B]

Here'sthe post I was referring to. Feel free to tweak it to fit your needs.
For a final shot, recreate your original routine. Re-compile it and see if it works. There is nothing wrong with it, apparantly.

[DSguru2B]

The following should work for you. Its your BASIC routine translated in C.

Code: Select all

#include "stdio.h"
#include "string.h"
#include "stdlib.h"

char* myStripChar(char *str)
{ //Declare Variables
  const int size = 1000;
  char ch;
  char* ret = (char *)malloc (size); 
  int ascii, i;
  i = 0;
  ascii = 0;

  while (*str) //for the complete input string
  {
       ch = *str++;
       ascii = ch;
	   if ((ascii >= 32) && (ascii <= 122) && (ascii != 91) && (ascii != 93) && (ascii != 94))
	   {
		   strcpy(&ret[i++], &ch);
	   }
	   
   }
   ret[i] = '\0'; //Terminate the string
   

   return ret;

}

[ady]

Thanx a ton.. DSguru, we are currently working on the issue .. I will try and let you know if anything works.