DSXchange

Spell your requirement out in words. Examples are good but should compliment the written requirements, otherwise people will be guessing what it looks like you may need.

Which is why I noted it was akin to a truncate.

Must not... note that they must exactly match the parameter name, case and spelling.

Not sure I've ever seen quotes referred to as 'inverted commas' before.

Are you asking if you need to quote them? No, not typically, unless perhaps the parameter value has a space in it.

A job needs to abort in order to rollback any uncommitted changes, auto-generated or otherwise.

There really isn't a way. You can perhaps 'truncate' them using CLEAR.FILE in a dssh session, but you'd need to know the job number and restore the auto-purge settings afterwards as they would be removed as well.

No, there's no need to explictly 'commit'. And I assume you would still use the APT_ORAUPSERT_COMMIT_ROW_INTERVAL or APT_ORAUPSERT_COMMIT_TIME_INTERVAL environment variables to control the commit frequency, even for a delete.

AFAIK, you can't count anything from the right-hand side so you'd need to check for the total number of occurances and take the next to last one. Perhaps a combination of Count() to tell you how many times the substring occurs in the string and then Index() to tell you where to start substringing fr...

Right() performs a substring starting from the right-hand side, so really wouldn't help you. You'd need to find all occurances of the substring and then take the last / highest position one, I guess.

I'm not aware of a UNIX that would care about the colons, but decided to ask. This smells like a bug... anyone report this to their support provider, gotten an official take on the issue?

It also mentions where to add them.

Me no gots EE.

Did you try searching? This exact same question was asked and answered just yesterday.

viewtopic.php?t=125407

Your question has already been answered and Convert() can do what you need. As noted, this FAQ discusses the same technique.