DSXchange

Then you'll need to determine it outside the Sequence job and pass it into the Sequence as a job parameter. Another Sequence could be used to accomplish that.

Make sure you don't lie to it about what order the data is sorted in or it will bust you. Also make sure that, as noted, your sorting supports the grouping being done or you'll be wasting your time. You can tell when everything is in alignment because data will flow into and out of the Aggregator at...

Not a thing, so off we go to (hopefully) the appropriate place. Hang on!

sunita, can you edit your post to add the 'Required' information, please?

I don't see how insert/update plays any role here.

Sequential files do not support multiple writers. Readers yes, writers no. Collect the two links together first, then write.

Which part do you need help with? Just the comparison? I'd suggest using the CRC32 function to build a checksum over the data fields in each record and then see if the same key in the other file has the same checksum. If not, something is different between the two records. If you are unfamiliar with...

Welcome! You have a registry issue or at least need to get into regedit to fix this. Do an exact search here for "menu bar" for the answers others have posted.

Repeating your error over and over isn't going to get you any closer to your goal of solving this. Have you contacted your official support provider yet?

What kind of "comparison" are we talking about here?

Sorry but that's not what was asked of you. After you Reset any of the aborted jobs from the Director, did a new log entry appear saying "From previous run..."? If so, double-click on it and post the contents here.

The first DB2 stage gets its last row and thus closes/commits before the second one does due to the Aggregator. No, there's no way to defer commits until everything completes.

Ah, you've been poking around.

No, don't delete anything. And you need to add "-64BIT" to the command so it creates a 64bit hashed file. The resize command doesn't use the dash, this one does.

Hmmm... piping cats. Not a good sign. :wink: UNIX commands are documented everywhere - the web, your server, you colleagues, etc. Try looking up what "cat", "grep", "cut", "tar" etc do, they are all pretty basic commands and easy to understand. Google can help...

In the pre 8.x world, you'd have to repeat the installation and it would go into "maintenance mode", allowing you to add any missed optional plug-ins as one of the options. I don't believe that's the case for 8.x but unfortunately don't know off the top of my head what the new procedure mi...

So... do you need help with something or are you just venting?