DSXchange

The pre-defined SDK Key Management functions can do this for you. These emulate a sequence in a database. Use a Routine activity to invoke.

Insert a Modify stage upstream to convert the string[8] to string[max=10]

I am going to presume you are happy with what SQL data types are. Data Elements are internal to DataStage. I like to think of them as "luggage tags" for data. For example, the SQL data type might be Char(10). What is it? A telephone number? A tax file number? A product code? Data Elements allow you ...

I think you're barking up the wrong tree. And, even if you do re-install, how do you know you don't have a defective component?

From where and how do expect to derive the maximum value if you don't want to use a lookup? A job parameter perhaps? As some point you are doing to need to query the target table to determine that maximum value, whether you call it a lookup or not.

Your support provider should be able to provide you with the URL that they would prefer you to use. Or you can search IBM's website if there's something in particular that you seek.

Viewing data in a File Set can be done with a job that uses a File Set stage with the correct control file name and record schema for that File Set; you can use View Data within the job design. Alternately, first cat the File Set's control file (the file with a ".fs" suffix) to learn where the data ...

What is the point of the Sequential File stage in your job design? It blocks all rows until they are all selected from Oracle. But the clock keeps running so your elapsed time is longer than it needs to be. The hashed file lookup is the most efficient possible; that is not where your problem lies.

Environment variables.

Use the five-argument variant of Ereplace() in which you can specify the starting occurrence and number of occurrences. But I still think Cats() or Splice() is a neater solution.

The reason they don't appear on the menu is that they are not available in the Transformer stage.

Your alternative is a series of "=" comparisons with OR operators between them.

Tell/show us how Prefix is defined/derived. Investigate the Cats() function and the Splice() function for easier mechanisms for adding a prefix to each element of a dynamic array. Cats(Reuse(Prefix:","),input.data) Splice(Reuse(Prefix), ",", input.data...

No, you can still form a sum or an average even though some of the values are non-positive. Nulls might cause an issue, but you can extract these using the NVL function. No, it's not that.

There is no decryption (unless you break the algorithm yourself). However there ought to be no problem passing encrypted values; DataStage passes the correct value when authenticating to databases etc.

Does the query work in another client, such as TOAD or sqlplus, or does it run out of resources there also? Summing 8 million values can quite possibly lead to a value larger than can fit in the target data type. You might like to use larger numeric data types than you currently have specified. Corr...