DSXchange

The "complex web" I described has to be in Sequence1, handling the exit status of job a and job b. joba (Warn) ----------> Any1 --------> LogWarn (Routine) | jobb (Warn) --------------+ You don't really need the LogEntry path I described. You can handle aborts through the sam...

I negelected to mention that this command must be executed while attached to a DataStage project directory (an "account"). Mea culpa.

Irrespective of any restriction on what you can and can't use, how are you going to define the "join"? Is there a stream of data that contains both EMP_ID and DEPT_ID in the same record? I would also make the point that the Hashed File stage IS a database stage, for all that they put it in the File ...

Failed here (Australia) with "user name/password incorrect (80011)". Operating system is AIX 5L 5.2, DataStage 7.1. Only the fully correct password would be accepted. Then again, my correct password is only seven characters. Hmm...

I'd call those "clients".

Yes there are only the five (including Version Control, which has been a part of DataStage since at least version 5.2).

If you're running 7.5 there is a rich set of expressions you can use in custom triggers. You could use these with the exit status variables of the jobs in the Sequence. If earlier than 7.5 you're up for a complex web of triggers; all normal exits go through an Any sequencer to the LogEntry routine, ...

The correct function names are TRIMB and TRIMF rather than RTRIM and LTRIM. But you can also use the extended form of TRIM, where the third argument of "B" removes leading and trailing. For example, TRIM(TheString, " ", "B") removes leading and trailing spaces. One function is cheaper to execute tha...

Please advise the patch identification. Others are seeing this too.

This capability was added to UniVerse after the split from DataStage, in the form of a function library called CallHTTP. It does not exist natively in DataStage. DataStage can certainly produce XML output. You will therefore need something external to DataStage to handle sending the generated text (...

It's almost certainly a BAT file that yfng created to contain the dscmdexport command.

Yes I'm sure (in DataStage BASIC and UniVerse BASIC expressions). Which is why I made the point - it's different from some other languages in this behaviour. :D

It might be useful to have some idea of your job design, in particular what stage types you are using, and of the exact release numbers of DataStage.

Try the /B switch with START. That is, START /WAIT /B BACKUP.BAT

How are you starting the command?

At a DOS shell, check out the /C switch for the CMD command, and also check out the START command, using HELP.

They don't appear in Designer until and unless you have imported a table definition from that data source into a category of ODBC\datasource, where datasource is the DSN that you use to connect.

It's frustrating sometimes, but it's the way the product works.