DSXchange

Welcome aboard. Please do not shout. (All capitals = shouting.) Why do you specifically want to use a Transformer stage? It is more usual to use an Aggregator stage to find a maximum (or perhaps an SQL query). It can, of course, be achieved, using the fact that stage variables are evaluated in the o...

No. There is a specific document for DB2. Its title is DataStage Enterprise Edition Configuring Parallel DB2 Connectivity - it was written by Ascential Software and originally issued on January 12, 2005.

Yes.
No.

Never re-invent the wheel where you don't need to. For example a set of date arithmetic functions can be had from here

That is because you have not purchased a premium membership.

Premium membership provides, among other benefits, the ability to read the entirety of the posts of the six premium posters. Premium membership is one of the ways that the hosting and bandwidth costs incurred by DSXchange are defrayed.

That's not an issue.

In DataStage, use any of the search facilities (including the Repository view, Quick Find or Advanced Search) to select what you want to compare, then right click and choose the "compare against other project" option from the menu.

Please mark this thread as Resolved using the green button at top.

While a nice gesture, it is not necessary to send a private message of thanks.

Then please mark this thread as Resolved using the green button at top.

Search for the error text. It has been reported, and solved, many times previously.

No need to shout! (All capitals = shouting) There is a very simple solution, to which others have alluded and which requires no lookups at all. The simple design is to use data sorted by ID, assemble the record in a Transformer stage populating the two phone numbers into separate fields with appropr...

How many columns are mentioned in the Sequential File stage in your job design?

When you say "concatenate" to R.csv, is the already existing structure of R.csv compatible with the added rows?

Yes it's still around in version 8.x, but IBM really have abandoned it in favour of FastTrack which, to paraphrase Craig, is way more betterer.

Get the SQL from the job log and see what actual statement is being sent to Oracle. Please post that here.

More than one secondary buffer in the group. One out of 12003 is not a problem.