DSXchange

Look for any opportunity for doing less processing, for example evaluating functions once in stage variables rather than many times in column derivation expressions, evaluating constants once when initializing stage variables rather than once per row, and so on. Once we see what you're doing more su...

The DDL pieces can be done in Before-SQL.
The DataStage job should select the first 10 rows and pass these through to an INSERT statement.
Create the key column up front and include the reference to the sequence within user-defined SQL.

When's the interview? These terms can mean different things in different scenarios, but I shall assume you are referring to some kind of ETL context. The initial load is where the target table is empty at the start of the run. Delta loads compare the new data with what's already in the table and onl...

INNER JOIN is perfectly OK, but you need at least one parameter marker so that a value can be passed from DataStage to trigger the SQL.

There's no bug. Therefore I stand by my position to make my answer a premium one. If you don't know the answer to this particular question you are still able to function as a DataStage developer.

This message suggests that the precision of your floating point data type is insufficient to handle the maximum number of digits possible in the CHAR data type. Note that this does not relate to the actual number of digits in the CHAR field, it relates to the size of the CHAR field. It might also be...

Welcome aboard.

Please show us exactly how you are referring to the job parameter in the Transformer stage expression.

Did you build the expression using the Expression Editor?

I don't know the answer to your question, but suspect that the answer is "no". Here is the link to sign up for premium membership.

What you get and what you expect are equivalent. Decimal representation in DataStage includes leading and trailing non-significant zeroes and placeholder to prove that precision and scale are being managed correctly. You can remove each with Trim() functions or, if you are 100% certain that there ar...

Life is not so easy in version 8. Are the jobs linked to regular or shared table definitions? In either case, what does the Locator property of the table definition tell you? Why not perform a Where Used analysis on the column? - You may find that it's used in a surprisingly small number of jobs, wh...

Something likeshould do it.

There is a complete answer in my previous post. Premium membership is not expensive, at less than 30c (Rs12) per day, and it helps to keep DSXchange alive. Please strive for a professional standard of written English on DSXchange. We are not a mobile telephone, so SMS-style abbreviations are unneces...

Try building one within the tool. See (and report) whether that makes a difference.

I don't believe it's possible. Consider the reporting mechanism. Each player process on each node has stdout and stderr redirected to its parent process (the section leader). Section leaders feed all things-to-be-logged back to the conductor, which logs everything it receives from every node. Of cou...

I don't think it's possible. There is no overwrite/append property in the Lookup File Set stage. But you can construct something like the following.