DSXchange

Time to mark this thread as resolved, then. The issue appears to be that either the database or DataStage is using milliseconds in timestamps by default, and the other isn't. Forcing "no milliseconds" via the date picture in TO_CHAR() has rendered the formats compatible. You could have changed the m...

Plug the network cable between the DataStage server and the database server back in, and/or ask the network administrator why the network keeps having failures.

Experiment with the NLS map setting. The CFF stage can manage EBCDIC internally, so try ISO8859-1 as a start point. Try NONE, although I doubt that that would work.

What precisely do you find to be unclear?

Rather than moving files the correct approach is to be in the $DSHOME directory when you run the uvregen utility.

Status 3 is not Running. Status 0 is Running. Status 3 is Aborted. This suggests you have something else you need to investigate. Why is the job aborting?

One million keys can be easily handled by a hashed file stage. It is true that three keys can also easily be handled by a hashed file stage. In this case the million rows are streaming through, do not have to be kept in memory other than one at a time or a buffer's worth at a time. As Craig notes, y...

Trim(Link.Column," ","A")="" can never be true unless the string contains no internal spaces. Trim() never removes the last of any set of internal spaces. Perhaps Trim(Link.Column," ","A")<" " would be a better formulation.

Welcome aboard. :D

Can you be more precise about what you mean by "merge"? Perhaps describe the expected format of rows in your result set.

Both the Server Job Developers Guide and the Parallel Job Developers Guide have a chapter on job sequences, in which all available job sequence components are described. You can also garner information from on-line help in Designer.

It is the server that needs to be able to find this DLL. To test that theory, find the DLL and copy it to a folder that is routinely accessed, such as the %WINNT_ROOT%\System32 folder. If the job now works you need to ascertain why its original folder was not being found. Do you happen to know what ...

Post the full detail of the error/warning message(s) you are getting. It may then be easier to diagnose.

Right now your question falls into the class "my car won't start, what's wrong?".

Etiquette Note
Please don't use all capitals. As with other Internet usage, it is regarded as "shouting" and is quite offensive.

If it's version 7.5 of DataStage, the MQ Series server must be co-resident with the DataStage server.

7.5.1A is a standard release, but does not compile or run parallel jobs on Windows platforms. 7.5x2 is a variant of version 7.5.1.1 and is the only pre-8.0 version that can compile and run parallel jobs on Windows platforms. Version 7.5x2 is not available for UNIX, Linux or USS platforms. The "x" is...

Use dsjob with the -report option.