DSXchange

Not nearly enough information for anyone to help you without guessing what it is you are doing. What is your Sequencer job doing? What does the 'LoadingIndicatorCDataSeqFile' job do? As a guess it sounds like you are launching a job for every record in a table... and swamping your server. You may ne...

As Ken asked - how large is your file? How wide? Sure, you can use CRC32 for this, but what a painful way to accomplish something simple. Leverage your operating system. As others have mentioned, check out the sort -u command. Do it 'before job' or (better yet) in the Filter option of the sequential...

From the command line I'm not sure, check the docs. I generally do this one at a time via the 'Job Report' routine Ascential posted at ADN. What version of DataStage do you have, btw? Kim Duke should be along sometime today to let you know about his offerings. He has written some very nice utilities...

Just a thought, perhaps we could consider 'opening up' the releases in the required DataStage Release field for the 7.x versions? There are enough differences between 7.0, 7.1 and 7.5 that sometimes we have to ask which sub-version (for lack of a better term) or minor release someone has. Some poste...

This all works fine but as I said possibly not done the best way. It means that the controlling job has no icons on the diagram editor. Nothing wrong with that at all. If you are worried about it, drop an annotation on the canvas explaining what the job is doing. If you have version 7.5 you may be ...

First solution Ken mentioned, Ray - attention to detail, lad!

HTML documentation is perfectly printable, do this all the time.

For this we would need some kind of commandline interface to the DS-designer. Is there anything available? In other words, no, not really. I know people that have done what you are contemplating, but it takes a very in depth knowledge of the structures of DataStage jobs and the target is usually an...

As Chuck mentioned - go straight to 7.5 if you can.

You should write a script to do the actual call to sendmail. In your job control, gather up the information that you need and then pass it as parameters to the script... let it do the work.

I always thought it was simply the number of occurances as it didn't really seem to matter what column you pass it to count. Mostly.

Turns out, it counts the number of non-null values in the grouping key(s).

Check your online help for the DSExecute function, that's one way. You can also choose 'ExecSH' in the before/after subroutine areas of a job - primarily before or after the job itself, but a stage as well.

Both simply execute your script.

Interesting, indeed. Not having had a chance to play with the DRS yet, I'm surprised it would log an error like that. Well, surprised in the fact that Oracle itself doesn't consider a query that updates zero records to be any kind of a problem. DB2 does, which is why I made my comment. And what in t...

The best way to solve the problem is to not use the FTP stage. In its place, a script and plain ol' command line ftp will work every time.

ray.wurlod wrote:A similar circumstance happens in Oracle; if you insert 0 rows, Oracle generates a warning that 0 rows were affected. DataStage logs this.

DB2. And you mean 'update' I do believe.