DSXchange

I wonder what makes them think inefficient SQL buried in stored procedures would be any better than inefficient SQL not buried in stored procedures?

Get "them" to create/modify the account with a non-expiring password.

Everything Ernie said is true. However, single sign-on is not yet available. A separate sign-on is required for each product in the suite, even though it be the same sign-on each time. This is an artifact of them having been separate products in the past. I believe single sign-on is in the roadmap f...

It is possible to add columns in the Modify stage. However, each must be derived from some input column in some way. Therefore there is no equivalent of setting to a constant or null.

Use a reject link from the Sequential File stage that reads this file. Rows will be rejected if they don't contain the correct number of field delimiter characters.

This "standard" is extremely dubious in my opinion, and showing ignorance of how DataStage can work best. Do we have a justification from the architects for this decision? (I'm sure the DBA's won't agree with it.) DataStage can perform "direct read" and "direct write", ...

In the roadmap for DataStage/Information Server (subject to the usual caveat: this is stuff they're thinking about or working on, with no promise to deliver or when) there is proposed a web console for monitoring production environments.

It was added in the 8.0 release if memory serves (maybe even in 7.5.3?) and there are two: Resource Estimation tool and Performance Analysis tool. Read about them in the DataStage Designer Guide.

Did you import a "table defintiion" from the fixed-width file and use that in the stage?

Let us know what output you get.

Just satisfy your mail server requirements - separate the addresses with comma, semi-colon, space - whatever the requirement is.

Int() can be used in a parallel Transformer stage. Instead of being "not sure", why not look in the list of functions when editing the expression?

If lkDiv.AMT = 0 Or lkpAmount.AMT = 0 Then 0 Else SomeAmt * (inAmount.AMT / lkpAmount.AMT) We don't want divide by zero errors, do we? For what it's worth, the Iconv() and Oconv() functions in your server version are redundant unless you're doing it to achieve rounding. In a parallel job, the Scale...

There is another thread currently active regarding this character (Char(191) if I recall correctly) which may have a possible solution involving the Char() function.

Yes. Per partition. Sorting is not global.