DSXchange

No, it's more Insert Else Update rather than Insert And Update from what I recall. Could be wrong as it has been quite some time since I've actually worked with the tool.

If you go that route, make sure you initialize / empty / clear the sequential file before you hit the loop as inside the loop you'll want to append to the file. That or have your mechanism be smart enough to overwrite on the first iteration and append after that.

Your update will only fire if the insert fails and for that to happen you basically need to violate a unique constraint, i.e. insert a duplicate key. Do you have such a constraint on your table?

mhester wrote:Sorry, did not mean to post that twice!

Unposted.

Re-read this thread. You are correct in that MERGE combines two tables, not one table and an input stream, hence the suggestion to do it before/after and trigger it with a single row into the stage.

There are dsjob options to list all projects and to list all jobs in a project, those should get you exactly what you need.

I'm actually not sure, never tried it as I tend to avoid those 'combo' actions. Why not give it a shot and let us know?

kennyapril wrote:where can I add them?

Pretty much anywhere but I'd suggest just after the INFORMIX ones and before the "fi".

Try the -jobinfo option rather than any kind of -run and see if there is anything in the output that shows if it is MI enabled or not.

No clue how to explain that one as long as you are certain you are reading and writing to the exact same hashed file. Worst case, manually delete the hashed file's directory and it will recreate it on the next run.

Add them to your dsenv file.

Do an exact search here for "unable to create Java Virtual Machine".

Thought about that but honestly don't think you can update values in that stage. Could be wrong, though but have no way to test anything.

Then it seems like it must be turned on for those specific jobs.

OK, let's go the opposite direction then. Do not mark the link as a Reject link and restore your 'LinkName.REJECTED' constraint value. Make sure you pick that from the Helper rather than type it in manually. Both of those approaches should work just fine. If they're not, we're missing something impo...