DSXchange

But one could have one output link per input link, each with a condition and that would send multiple mails, wouldn't that work?

(Sorry, I missed the "any"/"All" part of your original post...) If you have "All" set, then all of the inputs to the sequencer need to deliver a value, i.e. your "Routine2" and other triggers must be set so that the output is always present. How many outputs d...

Going by your first post, I'd guess that these are null characters. But there is also the ^A in there. Is your data actually expected to be ASCII or is it perhaps a COBOL file with some binary data?

The data is not junk, it is just not part of the displayable ASCII characters. You should check up on "cat -v" and/or "od -x" to see what your characters are, i.e. those you pasted are "^@" which is VI's way of telling that the charactes are Control-@ and in your editor...

Is your sequencer stage set to "any" or "all"?

Here a bare-bones loop structure: $INCLUDE DSINCLUDE JOBCONTROL.H Ans = "" * Generate sorted list of job names. Perform 'SSELECT DS_JOBS WITH NAME LIKE "1A0X"' * Read list to memory READLIST JobNames FROM 0 ELSE JobNames = '' CONVERT @VM TO @FM IN JobNames REMOVE JobName FROM Job...

I'm not sure about the next loop until constructs. Can you add some "CALL DSLogWarning('Inside xxxx loop with value yyyyy','')" type of debugging code to see why you aren't looping?

Remember that the userid used by DataStage is different from your normal login user and would require separate authentication.

The amount of data you can have in your lookup reference data is limited to 2Gb in AIX. (see http://www-01.ibm.com/support/docview.w ... wg21383512)

Thus your 6.7Gb of reference cannot fit into the confines of a lookup stage and you will need to use a join instead.

It does look like the authentication isn't working.

Can you connect from the command line using sftp or a similar tool using the same authentication as you do from DataStage?

do you also get the error if you write a new job - i.e. no cut-and-paste or save-as from the old job? If yes, then you have a problem which most likely cannot be solved here in this forum but needs to be addressed by your support provider. On the positive side, you would seem to have a reproduceable...

Just as with the original problem, Ray's response still applies. Have you checked what you've set the value to?

The question is a bit of a strange one to me, as it isn't really a DataStage one but more of a generic database type question. I will assume that the employee and department tables share a common key for a join to be made. Depending upon your data and common keys, you could do 2 parallel inner joins...

Well, the one you listed - 'DELETE DS_JOBS' is a good command if you want to completely trash your project; I don't know where you came up with that one. This UniVerse or DataStage engine is a complete environment including compilers, debuggers, file management, scripting, etc. The VOC (vocabulary) ...