DSXchange

I imagine it's possible, but have not given any thought to how. Depends to some extent on what you mean by "dynamic" and whether you allow QualityStage stage types into the mix.

If its Server what steps should be taken? Essentially posting the question in the Server forum. As a general rule - maybe even a universal rule - the APT... environment variables are not heeded by server jobs. However if you're using an Oracle Connector stage in a server job, then they may be - it'...

Yes, otherwise how would Oracle know which blank to preserve?

And that is true, in general. Non-NLS can transmit byte values faithfully.

So what's different between the two servers, or the two databases?

Use a Peek stage (or compile in trace mode) to determine whether the accented characters are getting in to DataStage in the first place.

For example, if DCount() were not in the DSParams file, which did happen in one point release. Or if DCount() has been removed from DSParams.

You can "sort of" achieve this with stage variables in a Transformer stage early in the job.

Could you post an example? I think I know what you mean, but am not totally sure.

the client's standards dictate the maximum transparency The BASIC language is easily understood - the "B" in "BASIC" stands for "Beginners'" after all. Resist stupid requirements! Standards are a fine thing, when used intelligently. Try not to work for Vogons in your n...

They do. It's a training class coded DX437.

The ones you mentioned earlier are for Oracle, not for DataStage.

If you are using UTF-8 or any other non-ASCII character set, might I suggest that you install DataStage with NLS?

And yet, curiously, I don't think it's the right answer. WISD is for when you want to expose a DataStage job as a web service.

I believe you need to investigate either the Web Services Client stage or the Java Client stage, depending on exactly how you want to retrieve the document.

Then you should have no character sets at all.

If DCount() is identified as invalid when you validate the expression, use Count() instead.