DSXchange

Did you try searching on keywords 'ParallelSortMerge is combined with its input'?

It works with sql wild cards as well right? Where is this information documented? I checked the Parallel developers guide, its not there. Unless its in a chapter other than Filter Stage.

Both require different mindsets for developing jobs. It will benefit you in understanding the differences of the two animals. And when to ask your client to do an upgrade

I really wish folks with Version 8.0 could give some insight on it. I still think that the underlaying design of DataStage engine will not change drastically. These tables will exist, maybe with a different name or structure.

Where are you trying to restart it from? From designer it will give you that error. But it will re-run from the director.

Are you getting any additional warning messages. Reset the job and see if you get any messages "From Previour Run".

The following should work for you. Its your BASIC routine translated in C. #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 (...

Search on the error message. I believe its been covered here before.

Well in that case as others have noted, you need to get the file on the DataStage server first. Then read it with CFF stage and then do your manipulations.

What is the meta data of your staging table as defined at the database end. Compare that with your target. Whats different?

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.

Give that condition to the mainframe folks. They can apply that condition while doing the extract.

It supports 'Like' boolean operator. Did you try using it?
For your example, it will be Col like '%ABC%'

Did you get any additional messages when you reset the aborted job?

That's one hilarious statement by kumar. Can't stop laughing...