DSXchange

"Nothing" is not the right answer. The change might not be in DataStage.

How did you query DS_JOBOBJECTS ? What information were you seeking to retrieve? Do you understand the key structure of DS_JOBOBJECTS?

Changing the "(As pre-defined)" values is not possible through operating system commands. However, you can change values defined in values files belonging to the Parameter Set. Values files are text files that reside in the ParameterSets sub-directory in the project. Within that there is a...

Have someone with the DataStage Administrator role open the Administrator client. You have only DataStage Operator role. If you want to be able to design, you will need to be included in the DataStage Developer role (or higher); after that has been done you should be able to use the Designer client.

You will need a premium membership to read the entirety of Craig's solution (for such it is).

Premium membership is not expensive, at less than 30c per day, and the revenue is devoted to keeping DSXchange alive by funding its hosting and bandwidth costs.

The routine should be present inside the Routines folder in the repository. And this looks to be a server routine and so for the routine to work, the Routine transforms also needs to present. The routines are called inside the transform, which in turn is used in the Basic transformer stage. That in...

In my opinion you should never create DataStage jobs that abort intentionally.

Query DS_ROUTINES on its key (DSRID). The following two queries give you an exact search or a search on partial name. Note that the routine name is case sensitive. (You can modify the queries to make this a case-insensitive search if desired.) SELECT DSRID FROM DS_ROUTINES WHERE DSRID = '<<RoutineNa...

If the source file is a text file, you could use a Filter command such as sed or awk to convert the pipe delimiters into line terminators. (Even though you are on Windows, the MKS Toolkit provides these commands.)

Are any of the connection values supplied as parameters? If so, are the values supplied for these parameters always accurate?

Welcome aboard, saintankit. Unfortunately a server routine will not serve the original request, which is in a parallel job.

For parallel jobs the routine must be written in C++

Jayakannan wrote:it has been running successfully for a week before this issue occured

What has changed? ("Nothing" is not the correct answer.)

Actually there is a third possibility, that someone with UniVerse knowledge has cataloged the routine from some other location than DSU.BP. Once we know the name of the routine we may be able to explore this possibility too.

There are two possibilities. The first is that the source code was never imported into your project. In that case you will need to track down where the source code actually is. The second is that the code itself has been removed from your project. Try a query against DS_ROUTINES to see whether your ...

Is the file missing a line terminator at the end of the header row?