DSXchange

This appears to be an error in OLE Automation, which is used by the DataStage clients. It's not possible to determine from what you've given us what the actual problem is; it may be as simple as PATH needing to be updated, it may be something more complex such as a disk fault. Involve your Windows a...

", INC" will never be standardized by USNAME into the main name field. You can use a downstream Transformer stage to append the Name suffix if that's what you require.

Not true, Mike. Len() counts characters, ByteLen() counts bytes, and LenDP() counts display positions (for example for Chinese double width characters).

Define the input field as VarChar and use StringToDecimal() function.

The entire process is fully and clearly described in the documentation. All the work you've done in the internal user registry will be lost. You need to change the Global Security settings in WebSphere Application Server, then you need to run the AppServerAdmin script to set the new admin user (whic...

No problem. Give them their own Engine, managed from the one Services tier as the other Engine(s). Use Workload Management to prevent overload on any machine (whether you stay with one, or choose multiples). I don't believe that a grid implementation will solve the particular problem that you have j...

Because "002250{" is not a valid Decimal number. The "{" character indirectly indicates that the number is positive. It's made up of the nybbles for "0" and "{". If you're sure that all values will be positive, simply convert the "{" to 0 before appl...

Check, double check and triple check the authorization in your Connector, or in the Data Connection object that it uses (and possible in the Parameter Set associated with that).

Test by manually overriding the user name and password with the correct values.

Welcome aboard.

I will be implementing a similar topology some time in the next three months, though a smaller installation so compute and conductor nodes will probably be on the same VM. We're still designing this.

Please note that there is no version 11.4. There is 11.3 and 11.5.

As a general rule storing only XML is easier achieved in files than in tables.

Storing XML plus other stuff changes the story.

What - exactly - do you need to achieve?

[Warning: every general rule has exceptions.]

It is generally not a good idea to try to manipulate the internal tables directly, as mistakes will tend to be catastrophic. At version 11 there is a suite of command lines that you can use to work with user accounts in terms of assignment to roles. Do you also need to revoke roles if users are no l...

Does it really matter? View Data may show you even a different order. Peek output to log may show yet another order. The point is, all the columns get through the design.

SIGINT can be thrown/caught if the job is stopped by an operator, and can also be the way that section leaders kill player processes when certain kinds of abort occur. Please check your job log for any other errors.

Balanced Optimizer does create a new job (you do not lose the old one). Paul is advising you not to throw away the old one, for the reasons he gave. In later versions (I forget exactly at which version it begins) Balanced Optimizer gives you the ability to decide how much of the job to push out into...