DSXchange

In a server job you can add a fourth stage, to dispose of the count (for example a Sequential File stage). You can form the count in an Aggregator stage.

Those three are the complete set. The DB2/UDB Enterprise stage has full parallel capability.

"PX" was only ever a marketing term.

The dsjob command is documented in the Server Job Developers Guide and in the Parallel Job Advanced Developers Guide - the option you most likely require is -logsum and then you can pipe the output through grep to highlight the item you are seeking.

Be more specific about "didn't work". Post the detail of the error message. Were any rows written to the Data Set?

No - these are for server jobs only. Scratch space is determined by the directories mentioned in the configuration file. Temporary space is determined by the directory mentioned in the TMPDIR environment variable.

If the join keys are VarChar, make sure they are trimmed of leading and trailing space characters. Make sure that your data are identically hash partitioned and sorted on the join keys.

Of course, Walter is not sleeping at present!

A sequencer can only make an Any or All decision to trigger its output(s) depending on whether its inputs have fired. It can not invoke routines.

In a job sequence, however, you can invoke DSSendMail via a Routine activity (clumsy) or a Notification activity.

Can you post the actual call to DSSetUserStatus() ?
The backslash is a quote character in DataStage BASIC, so this may be the cause. Try quoting the string.

I dont think so, because I have been able to see this even with the patch installed for SP2. Nonetheless, you need the patch for other reasons, particularly Job activities in job sequences. If you click on the single icon in each folder of the Palette, you get everything in the stage types branch of...

You are using the wrong tool. To start a DataStage job from a client too, use the Director client.

While it is possible to invoke dsjob from the Administrator client command window (using the DOS verb with /C switch), it is an entirely inappropriate mechanism.

InputField[ delimiter , start , count ] The delimiter asserts that you are dealing with a string (InputField) made up of zero or more substrings separated from each other by delimiter characters. For example "STRAWBERRY ICE CREAM" is a string containing 20 characters, or a string containing three wo...

Twenty years later Robert Pirsig wrote his second book, called "Lola" if I remember correctly. Long time between books. Not nearly as good, in my opinion.

Why shocked? If you remember the sixties you weren't there?

Don't you think "output file full" is telling you anything?

You've marked the topic as resolved. How was it resolved?

Challenge the assumption. You've just spent $squillion on a GUI tool that can do the job AND generate C++ code. So why do you have to "implement a business logic in C" ?!! Do it in DataStage. Open the generated C++ code generated by compiling the Transformer stage, copy the code into a document, and...