DSXchange

Is the environment variable's value set in the shell of the process that runs the job (dsapi_server or dsapi_slave, perhaps)?

Have you asked IBM or searched on their website?

The Remove Duplicates stage will return as many rows as there are distinct key values in your data stream.

It won't. For starters, there's no If in the expression, even though there are Then and Else. Second, you seem to be assuming some kind of loop through the characters in the string, which does not exist. Set a stage variable to contain all the characters that must be converted to zero, for example s...

4. What is the correct spelling of the second person personal pronoun in English?
5. In what way does DSXchange resemble a mobile phone? Then why are you using SMS-style abbreviations?!!

If you have QualityStage licensed you can use the VEMAIL rule set.

We don't do "urgent". DSXchange is an all-volunteer site whose members post if and when they can. If you need "urgent" help sign up for priority service with your official support provider and learn just how much "urgent" costs. Meanwhile why not Search DSXchange? You'...

Convert() function is perfect for this task, in both server and parallel jobs.

IBM usually advise against mixing platform types.

Therefore they're unlikely to document how to do it. Indeed, the most recent Installation and Upgrade Guide specifically prohibits mixing platform types between repository, services and engine tiers.

Is operator combination enabled or disabled?

Use Monitor or Performance Analyzerto report on the CPU consumption. This will provide guidance about which sets of stages could benefit from disabling operator combination.

{Key}

Or you could just convert all the non-numeric characters to "" then store in a BigInt and proceed. Hence Craig's question about what format of number were you looking to use.

How many nodes? (Let me guess four.) Please let us know ALL the settings in your Sample stage. Each node is taking a 50% sample. Out of 23 rows on each node, that will be 11.5 rows. There is no "half row" so you get 11 on each. Actually the arithmetic is wrong there - it should have been 1...

Locate is not a function - it's a statement type in the DataStage BASIC programming language. Index() can do what you require, but you may need to provide separator characters on each string to test if there are nested substrings that might yield false positives. Index("Open|Progress|Hold|Faile...

This is a bug of long standing, and the solution is "don't login using Omit" as you noted. Without Omit login is via TCP/IP and passes user name and password credentials. With Omit login is via LAN Manager and passes a Windows SID. Sequences (but no other job types) write to the client whe...