DSXchange

Who said you have to use UNIX script? That information was not part of your original question!

Is this a join, a union, or some other kind of combination? Would it be assisted by indexes if performed in the database?

There's only one way to find out. And YOU have the database!

Use Excel. Do it manually once, and record a macro. Now you will have VBA script that you can adapt.

It's not something that you would sensibly expect DataStage to be able to do.

Yes there is. The DS_AUDIT table contains the DELETOR and date/time deleted fields.

It's not difficult, it's merely tedious.

That's a huge topic, one that could not easily be answered in a single reply. Why not Search DSXchange for examples? For instance, a search on CATEGORY will turn up answers to your second question.

They're on the client because the Information Analyzer and QualityStage Match Designer use them from the client.

What's hard about it? If you can change one you can change any number. The word you really wanted is "tedious". It's not hard. Many things in programming are tedious if done right. But, if they're done right, they're typically only done once.

Use Optim.

NLS is "National Language Support" - a misnomer because it's about character sets and locales, not about languages. NLS provides the means to map external character sets (for example SHIFT-JIS for Japanese) into the Unicode used within DataStage. Actually, if NLSMODE is 0, then NLS has bee...

Always use trimmed VarChar on both inputs. Char is always untrimmed, so you need to have them identically padded.

There is not. "Active Sessions" is transient information only.

The disconnect interval can be configured by an Administrator.

Why necessarily with PadString() ? There is an easy way to left-pad with spaces. Create a string of that many spaces, concatenate the data, then extract the rightmost that many characters from the result.