DSXchange

Those are not warnings. Please post the actual warnings (they have yellow or red icons in the log).

If you're reading the detail of each event anyway, simply exit the loop after you encounter the "job starting" event.

But you still haven't really told us (in English) what you're trying to accomplish. That is, a specification for the routine, and where you intend to use it.

Option -warn 0 disables abort on warning count altogether.

I counsel against using this. In fact, I strongly advise creating jobs that don't generate warnings at all.

Unblocked that one, since I'm asking questions rather than offering premium advice.

Depends how your cutoffs are set. On your choices of blocking fields and matching rules, these will be quite close, but have different match weights. You have a number of choices. For example, you could make GenderCode a blocking field, or make GenderCode subject to special variable handling (critic...

MatJoinOp is the operator that looks after the join on the combinations of blocking fields from the two sources. I presume you have specified these correctly, since the Match Designer won't really let you do otherwise. Is there any more detail to the error message? Might there be null values in the ...

Why did you "decide to use DataStage TX"? Are you aware that there is no longer a product of this name? The transformation extender technology is now marketed by IBM under the WebSphere brand.

Where and how have you set $APT_STRING_PADCHAR ?

The trailing null characters may actually be stored in the DB2 table. How did these values get populated (DataStage or some other application?). If they are already in there, then a Trim() or Convert() function would be a good way to eliminate them.

Is there no data governance at all where you are? You simply can NOT unilaterally remove or change your client's data without approval. There are plenty of ways of doing so, as a search of DSXchange will reveal, but I want to be assured that you have your clien't permission to effect changes in thei...

hJob is the handle to the job, not the job name.

You can not use hJob as an argument to DSAttachJob() function.

The job name is retrieved from hJob using the DataStage API function DSGetJobInfo().

Don't know. What does the Job Control code reveal? (I'm not at a site where DataStage is installed at the moment - I'm preparing to do the installation.) That said, I expect that it's always been that way. As with shell scripts, command execution is synchronous. The script (or sequence) waits for th...

There ARE linefeeds in your data. Live with it.

Check with the data owners before doing anything radical like changing their data.

You overwrite vEventDetail each iteration through the loop, but don't call DSSentMail() till you exit the loop. Why don't you specify in English what you want to achieve?

Every project has a VOC, and it's a hashed file not a regular file so you can't edit it with a standard editor - you need to use something like the UniVerse line editor ED. Your question suggests that you should hire someone experienced - if you get this process wrong, you render your project unusab...

Converting the newlines gives me a delimited list that the StartLoop activity can use easily.