DSXchange

Are any error messages produced? Do both jobs (the one that writes data into the Data Set and the one that reads from the Data Set) use the same configuration file? Can you view the data in the Data Set using the Data Set Management tool?

You won't be able to do it in one Aggregator stage, since you need sum(col8) in one of your calculations. So you will need at least two Aggregator stages.

Tip: include an explicit Sort stage on the input to the second Aggregator stage to specify "don't sort (previously sorted)".

Change the job sequence design. I am inferring that you want to run B if A aborts or C if A succeeds. All you need is separate triggers out of A. A -----> C | | V B The trigger from A to C is a custom trigger with the expression A.$JobStatus = DSJS.RUNOK Or A.$JobStatus = DSJS.RUNWARN while the trig...

They indicate that you've got buggy software, or an operating system that is having difficulty with file pointers for pipes, perhaps because it is overloaded or you are running out of file descriptors. Contact your support provider. Also ask your Unix system administrator whether anything has appear...

Hello, I have a requirement where I need to do a lookup on a field. Before doing the lookup I need to sort the incomming data. I need to sort it in the ascending order before doing the lookup (The hash file has the values in the sorted manner) No it doesn't. Storage in hashed files ("Hashed", you w...

Korn shell on Windows?
The dsjob command can take multiple -param options.

A better design is: seq4--->sortstage--->seq5 In seq4 use a Filter command cat seq1 seq2 seq3 An even better design is not to use a server job at all, but an Execute Command activity in a job sequence (this may be the only activity in the sequence, so it appears to be a job). The command would be ca...

DataStage does not support any languages. Use of the word "language" is misleading. DataStage NLS supports multiple character sets, but only one at once. It does this by placing maps at all boundaries between data and DataStage. These maps convert from the way in which the external data are encoded ...

Try applying DateFromDaysSince() function to the date after converting from string.

After obtaining the job name check that that value is not DSJE.BADHANDLE (which means that the attach failed).

Use the AddMonths() routine (from my date routines) with an offset of -2, then apply the MONTH.LAST Transform to get the last day of that month.

Welcome aboard.

Timeouts most commonly occur when the server machine is overloaded. Search on this site and elsewhere (for example IBM DeveloperNet) for details.

Did you Search the forum?

The message suggests that the DLL that supports the DB2 stage could not be found - which in turn suggests that that particular plug-in stage has not been installed/registered in your project.

I'm not aware of any. Your most likely is www.ibm.com/certify - maybe ask via the "Contact Us" link there.

OK, try it without reference to the parameter markers. The markers are probably not being replaced because you did not declare a column as Key.