DSXchange

As noted, you need to use DecimalToString on the incoming decimal first then concatenate and lastly use StringToDecimal to convert the end result back to a decimal.

The insert must fail for the update to trigger and it will only fail if you have a unique constraint over the column(s) involved.

Well, that's certainly not the documented behaviour nor what I recall from personal experience in the past. Perhaps contacting your official support provider is in order?

Out of curiousity, what exactly is in your $DSJOB_LOGON_CLAUSE variable?

Neither. We all see it and it's not something on a fix list... it's why there's a big green banner at the top of the search page that states: This search database is huge! Remember: Searching for a single word or even a few common words will probably cause the search to run out of memory and abort. ...

Both -jobstatus and -wait make it wait for completion so it can report the appropriate status back to you. If you don't want it to wait, do not include either option.

This happens to you or everyone?

That or "Timed out while waiting for an event". ... Wow, that search gives me exactly 6 hits. All of which more or less say "why don't you try searching for "'timed out while waiting for an event'"? That's why this is such a helpful site. :? Search fail... it returned 67 ma...

Split to your own topic, linked back to original thread.

Or DSSendMailTester as well, also check their source code which can be copied and adjusted to your need.

What's your goal here?

... or you can just give what James posted a try.

If you want to pursue the first method, show us the syntax you used and we'll go from there.

You have to split the date from the time and convert them separately.

Not arriving at a solution doesn't mean you start over in a new thread. Keep pushing in your original thread until you get your solution.