DSXchange

I would have suggested that, but I was asleep while you solved it! Well done.

Did you use the migration tool (concierge service) to migrate? Among other things this picks up DSParams settings, message handlers, etc.

... provided, of course, that you've also set APT_CONFIG_FILE.

You can't. A sanction of some kind is the only way.

Yes, on most Windows platforms uvodbc.config is populated automatically when Import > Table Definitions > ODBC is selected. But, as you note, it seems not to work when the operating system is Windows 2008, hence my question about editing the file. If uvodbc.config in the project correctly refers to ...

The most accurate way is inspection of the order documenation between the reseller (or IBM) and your organization. Contact your account representative.

If it's one attribute per line like that, constrain the stream not to pass any line containing "><"

No, unless you encase the password in quote characters.

Licensing is now on an honesty system. Check only those components that you have actually purchased. If, when IBM audits your site (which the licensing agreement allows them to do), they find you using unlicensed software, you get to pay for that software back to day 1 (probably plus penalties).

Even though it may be counter-intuitive, try reversing the pairs in the table definition. TargetValue:string = lookup_string_from_int16[{default_string='N'}('N'=1; 'Y'=2;)](SourceName) Note, too, that default_value property is only for int data types - for strings the property to use is default_stri...

You still need 'N' in the lookup table, even though you've set it as default value (if I understand your requirement correctly). Can you be more specific about what "failed" means in this instance? What output do you get?

You need to obtain a definitive statement concerning how these characters are encoded in the target table (for example SHIFT-JIS, UTF-8), then ensure that all DataStage mappings and all database mappings are compatible. For example if your target is Oracle, make sure that the NLS_LANG environment va...

A Cross Domain analysis asks for base and pair. Looks to me like you haven't gotten into that workspace at all. From the INVESTIGATE pillar menu it's the "Key and Cross-Domain Analysis" option. It is feasible for the base and paired tables to be the same table, if you need to investigate w...

Information Server (of which DataStage is but one small piece) does indeed require WebSphere Application Server. The new architecture is service-oriented, and it's WAS that delivers the services: things like login/security, metadata access, metadata analysis, and so on.

Have you reset or recompiled this job? At least until you get it right, set the warning limit to, say, 50.