DSXchange

I once went on a blind date and that "did not look good at all" either.

Be precise. What did you expect to see, what did you see, and why do you believe them to be different? What query is being executed? Is it a generated query or a user-defined query?

Are the Oracle environment variables - such as ORACLE_HOME - correctly set (in dsenv) for DataStage processes?

You should not need to enable NLS. What precisely is the problem, both with Unicode set and not set?

You can provide a default value for every field.

To learn how, create a table definition using the GUI, with default value(s), then go to the Layout tab and look at its record schema. That's what you need to do in your schema file.

Look in the DataStage BASIC manual for an Appendix containing EBCDIC and ACCII codes. As to why they're not "translating" properly that will depend largely on how you are getting them out of the mainframe. Examine the received file with a hex editor and see what's actually arrived on the UNIX machine.

How about a job sequence with a StartLoop activity specifying the "list of things" (file names), possibly initialized by an upstream command or routine into a user variable?

In which particular circumstances do you mean? Or are you seeking a "one size fits all" answer, perhaps to an interview question?

Yes there is and, if you have the plug-in, you have its documentation in PDF format.

Welcome aboard.

The "preferred" character map is the one that is used to encode your data. So, if your data are encoded using UTF-8, then use that. If your Chinese data are encoded using BIG-5 or GB2312, then use that map.

Most character maps include what you describe as "English" characters.

In version 8, which your post shows you have, few of these apply. Your login authentication is managed through the Information Server login/security service. 1. UV.ACCOUNT is one of the places where project existence and location are recorded. It is the table of record for the Administrator client's...

No.

Among other things a project name is a database schema name. You can't rename database schemas either. (That's probably the main reason you can't rename DataStage projects. It's also the reason for the limits on project names (max 18 characters).)

There are two questions: installed and enabled. If you have installed NLS but do not wish to use it, set NLSMODE in uvconfig to 0 and regenerate. This will disable NLS. The only cost will then be the small amount of disk space taken up by the NLS maps. You can not uninstall NLS. You can only uninsta...

1) Yes.

2) It's not "instead of". You can expose either server or parallel jobs as web services.

Browse this forum and Ernie's blogs to learn a whole lot more about RTI, including its new names (SOA, WISD, WISL, AOYC*)


* acronym of your choice

Aha! New information. Your regular DataStage parallel configuration file also covers QualityStage jobs.

This may also prove useful in your presentation.

Or maybe not.