DSXchange

There is no function out of the box. Depending on how different from each other the items in the delimited list are, you *may* be able to use the Index() function to perform a search.

No, because it's not officially supported by DataStage. Even I don't use them (though I do know how, from my UniVerse expertise). If you must everything you need to know is in the DataStage BASIC manual, but you won't get any official support.

This is actually an error with the connection to Sybase. It is reported by the Sort stage because passive stages do not have processes and therefore can not report their own errors. Make sure that the columns defined in your job match those in the SQL query, both in number and in data type.

You can do what I suggested above - simply form the intersection of the sub-queries. If you want to attack it from the other end (that is, beginning with a particular parameter name) that's a fish of an entirely different colour, and a rather more complex query. Indeed, one that would take more time...

It's a simple matter of sending money to IBM, presumably through your local vendor.

Not without you telling us what you're doing - what columns you're using for blocking, what other columns you are using for matching, why you chose these particular fields, and so on.

The answer is yes, but it's messy. Jobs With Encrypted Parameters You would need to unpack the CParameters collection in the ROOT record for the job in DS_JOBOBJECTS, and then decode the enumerated parameter type. Parameter types are in the multi-valued field #19 in this record. From JOBCONTROL.H yo...

The reason I asked is that DSR_PROJECT is cataloged separately in each project. If the problem only occurs in one project, then it's probably the catalog entry for DSR_PROJECT (one of the helper subroutines in that project). If it's every project then the problem is more likely to be associated with...

Since NULL can not be compared to anything (even another NULL) I believe that what you are trying to do is not valid. Handle the nulls by converting to in-band null or dropping those rows upstream of the Change Capture stage.

I did not ask about other jobs, which was a given. I asked about other projects.

dsjob has an -import option but it only imports job executables as far as I am aware.

That hardly meets the requirement to "call routine through command line" though, does it?

You could write a main program too, if you knew how.

What has changed on the system (not necessarily anything in DataStage - ANYWHERE on the system) since last Friday? Are other projects on the same server accessible? Has a connection been dropped? Have you tried re-booting the client to clear any crap - such as handles to disconnected sessions - from...

No. In the same way and for the same reason that you can't invoke a C function from the command line. There is no argument-passing mechanism from the command line. Nor can you call DS routines from the TCL prompt. Your assertion that you can is wrong. If you disagree with that please provide an exam...