DSXchange

How exactly are you setting USERSTATUS in the first job? FYI, you don't need that UserVariables stage, the Sequence can pass what you need directly.

Only if you tell it to.

You've gotten appropriate help, the functions listed are what you need. Your issue with the "accuracy" of the call to DSGetLinkInfo (based on your DSJ.ME usage) is the where of it and what you are passing it. That would only work "after job" and you need to make sure the stage yo...

That -1 doesn't really tell us much other than 'something went wrong'. One way to help with debugging is to add COMMAND /Z to your batch file to have more diagnostic information logged. Or just simply 'echo' something inside the batch to see if it even gets that far. Also try passing the full path t...

Check out the DSGet* API functions for both links and jobs. Off the top of my head, DSGetLinkInfo with LINKROWCOUNT can get you those counts and I believe DSGetJobInfo can get you at least the elapsed time, not sure about the CPU seconds but can't imagine that bit is all that critical.

They're going to have native Windows Excel files sent to a UNIX server for processing? Not a good idea. Have "them" convert the files to csv format by doing a 'Save As' in Excel first and then transfer the csv files.

No, there's nothing special you need to turn on or off, this should just work. Can you drop some 'breadcrumbs' into your routine and batch? Call DSLogInfo and/or echo enough information to see where it might be going astray?

Please mark this topic as Resolved and post your second question in another post.

Hmmm, just the Array Size, I believe. And yes there will be a "performance" impact but if that is what it takes to solve this problem...

Yes, the job is still "RUNNING" regardless of before job, during job or after job... it's all running. And as noted, your Sequence trigger will be fine.

Ok, thanks for the details. First question: are you specifying full paths for these files? Or does the batch file 'cd' to the proper directory first? Want to ensure the files are actually being found.

I disagree. Since the job is generating the surrogate value, I don't see why one cannot include a check on the immediately preceeding insert to verify that it was not rejected and only in that case increment to the next value. In the event of a reject, reuse the last generated value. And from the ou...

Trying to recall... I no longer have access to any of those email communications. Went round and round with IBM but did manage to get them a reproducible test case and they acknowledged the behaviour was not correct. Pretty sure they said it was something they corrected (or would correct) in a later...

JP - I split your question out into its own topic, jumping on the end of other people's posts is frowned upon here. Now, you have one of your very own and have full control of its destiny. :wink: Going to need some details. So, you've used the "Test" facility to make sure your routine does...

What's the confusion here? The error message spells things out for you very explicitly. While you can run a "UNIX" command on a DOS server (thanks to the MKS Toolkit) the opposite is not true. At least not out of the box.

Switch to the UNIX flavor of that move command: "mv".