DSXchange

1. You need backquotes to capture the output of a command.

2. You are doing way too much work. Your entire solution is possible in a single command, such as

Here are some examples of a simple substitution encryption (and associated decryption) server routine. The Base string should consist of sixteen unique printable characters, ideally all the same case. These routines are intended to handle 7-bit ASCII (that is, Char(0) through Char(127)). FUNCTION En...

This suggests that there's a line terminator in your actual data.

Maybe you don't have read, write, execute permission to the Classic folder and therefore can't create the QS_TEMP folder.

(I answered about the server because you asked about the server.)

Maybe not every codepoint value is two digits long. Try something like this in the first loop: Then decode in threes not twos in the second loop.

You've already researched more deeply than I have. That they're stored in an XMETA table seems reasonable, since only the services use them.

Inspecting the Job Control code generated by compiling the sequence will answer this question for you. Please post the results of your deliberations.

SELECT MESSAGE FROM SYS.MESSAGE WHERE @ID = '020548'; reveals that this code is the generic message "Aborting", which doesn't help very much. My guess is that the total of your field display widths exceeds the device width. Reduce the FMT values or increase the width parameter using the S...

Check the sequence log to determine whether the Notification activity was executed. If it was, there's a problem with sendmail(). If it was not, there's a problem with the sequence logic.

Have you tried ensuring that TMPDIR is a local disk?

It looks to me like there's only one combination of keys that match. Any other nodes will be idle for this link.

DataStage server jobs do have an interactive debugger. Creating one for parallel jobs is on IBM's roadmap, but it's a huge technical exercise - just imagine some of the challenges - for example tracing a row that may suddenly jump to a different machine on the network.

... or the other way around - you're selecting the fields (maybe because RCP is enabled) but the fields are not named on the output link of the stage.

If NLS is not installed then all you can work with is ASCII.

Try using VarChar(96) in your job design.