DSXchange

Even more amazing, there's a list of worldwide telephone numbers to be found on the support portal. So if you really, really, really need to use the telephone (registration is still required), you could find the number here for New Zealand. Isn't technology wonderful? You'll still probably end up ta...

Do you mean some posters don't have the Search menu option?

And, in short, you didn't understand what you were doing. This is not the correct procedure for moving to a new server. By copying all file system objects, you are preserving all entries that refer to the old server (as you discovered). The correct procedure is to export all projects, install and co...

Also try moving the literal ahead of the input column.

I'm certain this question has been asked and answered in the relatively recent past.

It is starting to feel like an interview question.

FranklinE wrote:Andrew, pie is easy. Π is an irrational number and never easy.

... unless you live in Indiana, where the state legislature in 1897 considered a law decreeingthe value of pi to be 3, or 3.2, or 4, to make it easier for school children to learn.

Convert() replaces characters on a one-for-one basis. You will need the pxEreplace() function, which does not come with DataStage but source code for which you can find on DSXchange.

Welcome aboard.

As far as I'm aware there's nothing out of the box, but you could create a custom stage using the Trillium API.

One of the topics is "A Detailed Look at IBM InfoSphere DataStage 9.1". Tuesday at 16:30, South Pacific I.

So maybe there won't be a version 8.9.

You can log PMRs through the support portal. You don't need to use the phone. (The person who answers the phone is probably in Bangalore anyway.)

ASAP

(That's how you wanted me to reply.)

You need to look in the logs for more information. It may be the WAS logs (SystemOut.log and SystemErr.log) or it may be the export log (probably in $TEMP).

The literal ZQUSZQ instructs the rule set to use country code US in cases where it cannot determine the country code. The default country code, if you like. In this case the flag is set to "N" to indicate that it's not established as a confident selection.

That's not what the Min() function does. Check the documentation to find out what the Min() function does. The solution is most easily wrought using a pair of stage variables that you use to compare the value with its value in the previous row, and update only if it is smaller. It is not necessary t...

Given the arbitrary number of integers in the range I'd rule out using stage variables, but would definitely rule IN loop variables in the Transformer stage.