DSXchange

In any case the old paper capacitors leak after a certain age.

A fork-join approach would work too.

Split your stream into two. One side runs through an Aggregator to count the rows per key. The two streams are then combined using a Join stage to effect an inner join.

Find out where libclntsh.so.10.1 is on your system, then verify whether or not its parent directory is mentioned in the shared library search list (LD_LIBRARY_PATH) used by the DataStage user (that is, the list set up in dsenv script).

They did a Search and found the solution(s).

The solution is discovery. Go to the related logs if necessary, and discover what those unrecoverable errors were, then correct whatever it was that caused them.

Yes and no. QualityStage probably is the tool, because you will get both of the "standard" spellings (the ones left over from Dutch rule and the allegedly simpler Bahasa Indonesia spellings), but you will also get mis-spellings, and that's where the uncertainty thresholds will be useful. I...

Welcome aboard.

This forum is for WebSphere Transformation Extender. Is that the product that you are using?

If not, please post in the DataStage Enterprise Edition forum.

Vista is definitely not a supported O/S. Further, you will probably find that MKS Toolkit's telnet service logs in first, so that the DataStage telnet service can not get port #23 when it tries to start.

You can inspect the generated C++ code in the RT_SCnnn directory, where nnn is the job number.

In theory it's left to right, as Craig believes, but the optimizer may make "decisions" that change that. Inspecting the generated code is the only way you can be sure.

fbello wrote:My development DBA is on vacation and the production DBA , i can't join him.

I think also that your company has an issue with management of vacation times/access to alternates when critical roles are not being performed.
Bonne chance!

Remove Duplicates stage is the easiest way to capture the first record of each group.

As noted, the keyChange column that can be generated by a Sort stage can also be used to flag the first record in each group.

Workaround might be to send to a list address that redistributes the email appropriately.

You can always "pretend" by using an ODBC driver for text files.

This is an excellent solution if you're billing by the hour! (It is likely to be very slow on large files.)

You appear to have a mix of WCHAR and CHAR data types, and to be transferring data between them. WCHAR may require more than one byte per character for storage; DataStage is alerting you to that fact and the subsequent possibility that data conversion errors might occur. If you are 100% confident th...