DSXchange

dspxlearn - my Google here always goes to German (not English) pages so I can't help you much. You can try to search for "outlook att attachment" and you'll get a lot of hits - hopefully one of the first ones will contain the answer. If you do get a definitive answer please do post it. There's a Mo...

Is this just from your client machine or from others' as well.

I wouldn't worry too much - displaying row counts in Designer is purely cosmetic and just a convenience - the rows are clearly being processed satisfactorily.

Still searching for the antonym for "gormless".

There is a radio program/newspaper (Sydney Morning Herald) column (and book) in Australia called "Dagg's Dictionary" about words that don't exist but should. Details of the book are here

That "solution" is to do nothing, and let the database handle it. You will, as a result, end up with warnings in the DataStage job log, or in a bulk loader's log file.

It will never be a better solution than prevention.

Do you believe that U would be interested?


I understand - from the most recent post - that U is currently working on a server-only site.

If no job stream uses more than 50% CPU (which you can determine from Monitor) then you can have twice as many job streams as processors. This might be concurrent jobs, or nodes in a configuration file, or some combination thereof. A processing node, as noted by others, is a purely logical construct...

mcs@rajesh wrote:As i am Working in Unix i need to rely upon it for certain functions for example date etc.

Why?
They are also available within DataStage.

You can have explicit Warning (or customer Warning or Error) trigger leading (eventually) to a Terminator, which can abort the job sequence.

Your job will experience the same delay as View Data while the database is assembling the result set. During this time the stage status (as shown in Monitor) will be "Starting".

You still haven't explained where the three different sets of values come from, and how you know that 871 is correct.

For example, were the values obtained on two separate runs? Have you verified by performing a line count on the output file?

No.

It is a commercial reality that DSXchange costs money to run. It carries no advertising. Premium membership is one of the ways that hosting and bandwidth costs incurred by DSXchange are defrayed.

I do not intend to undermine this mechanism, nor to create the precedent of having done so.

Look at the square-bracketed components of the messages. You are successfully getting through to SQL Server - indeed the message indicates that you're connected. That it displays as a warning in DataStage results from the fact that DataStage expects a connection request to complete silently if succe...

Hashed files are completely "within the walls" of DataStage. Mapping occurs as data pass "through the wall" between the outside world and DataStage or vice versa. Therefore hashed files do not need mapping - they can quite happily store the Unicode data (in a UV-UTF8 encoding that preserves the dyna...

All the US-based developers I know can be found right here on DSXchange.