DSXchange

I think you do, unless you have additional information which you have not shared about the likely non-numeric characters that may appear in the data.

Is your NLS locale set to CA-FRENCH, at least for the CHAR category?

Did you bother to Search for an answer?

There are usually two icons. "Web console" is for Information Analyzer, while "Console" is the one for Information Analyzer.

The Administrator client sets project-wide defaults for any subsequently-created objects.

Unlikely that you can detect it from the timestamp; you probably need an extra column in the data or to read the TZ environment variable. The latter will yield the time zone of the DataStage server.

Yes but you still have to build the calendar table, and you need the rules to do that.

Yes but you still have to build the calendar table, and you need the rules to do that.

How many nodes in your DataStage parallel execution configuration file?

Not enough information; we are not prepared to guess your job design, you have to tell us what it is. Otherwise your question is in the "my car won't go, what's wrong with it?" class.

DSGetStageInfo(DSJ.ME, DSJ.STAGENAME) will return it, but I'm not sure how to invoke DataStage API functions from the Java Transformer stage.
There may be some read-only properties in the Properties collection; you will need to research this for yourself.

The OP needs to apply a patch/fix, which ordinarily requires DataStage to be shut down. This will include terminating dsrpcd. Otherwise examine the ds.rc script in the sample directory to learn the individual commands.

In that case there is no mechanism I can think of to prevent them from exporting. Making the project a protected project will prevent them from developing in it.

The stage itself will not cause any deadlocks; it is your design that will. Check that the partitioning is key-based so that the same key can not occur on multiple partitions.