DSXchange

Write it as an after-job subroutine rather than as a transform function. That is, change the routine type.

This will destroy your source code, so make sure you've preserved that first.

Citizenship requirements? Does Smartbridge sponsor work visa? These questions are important to anyone outside the US (outside the Republic of Texas, perhaps!).

Have you done a Search of DSXchange? I'm sure that this question has been answered previously.

float(2,5) ?!!! You're claiming to have two significant digits in the entire number yet five digits following the decimal placeholder. In any case, float and dfloat don't take precision and scale arguments.

Here's a challenge.

Assuming you have Balanced Optimization, find at least four.

3. It doesn't. It's random. But, for a large enough number of rows, random distribution will be close enough to 1/N rows per node.

In an interview I'd still go with "there's no environment variable of this name". It's good to see the PHB discomfited.

In a sequence check for the existence of any XML file in the receiving directory and, if they are there, process them (Folder stage is good) them move them to a different directory. Repeat.

The Distributed Transaction stage is probably what you're looking for. Or, if you're using a server job, the ODBC stage allows for a "grouped transaction".

Is this an interview question? How hard can it be to press F1 on that page and read the help file?

You can find this information on the IBM web site. Most compilers offer a -version option.

You can't disable NLS at a project level, but you can set the project default map to NONE, which is very close to the same thing.

Yes, just as soon as you can tell us how you run Excel on UNIX.

Seriously, though, Excel worksheets can be accessed via ODBC. You will need to source a third-party UNIX-based ODBC driver for Excel.

If your source is a database table, you can use a recursive SELECT statement. Some database servers have specific syntax for this, in others you may need to script it. There's nothing within parallel job stage types for undertaking this kind of query, unless you'd like to string together 24 Join sta...

Why did you post in the server forum? Is there a maximum number of months? If so, a couple of stage variables, some If..Then..Else logic and some arithmetic should see you through.