DSXchange

What have you done to try and fix it in the last month? Was your official support provider able to help narrow it down at all, provide any patch?

He's a thinker, that James fella.

As am I. Note that I put 'single' in quotes on purpose as you can run multiple commands from ExecSH with proper statement terminators. For example: first_command && second_command I'll routinely do something like that to first cd to a directory and then run commands on the contents of that d...

If all your script does is execute a 'single' command then there's no need for a script, just execute it directly via ExecSH.

It sounds like you've got your timestamps backwards. Look for other functions to convert the result to a time, they are all documented so you shouldn't really need someone else to look them up for you.

For a fixed-width sequential file column, how else would you represent it?

Start with SecondsSinceFromTimestamp().

You can still have trailing characters (including spaces) in a varchar that need to be removed, but don't fall into the trap of trying to trim trailing spaces from a char.

Yes, several. Let's start with the standard response: search the forums for ETLStats, a package that Kim Duke gives away from his website. You'll also find other discussions on rolling your own using either the DSGet* functions or their dsjob equivalents, depending on where you want to implement thi...

Hmmm... I wonder what the heck I was thinking of then?

I'm really curious what the goal is here and I'm wondering if all this curious energy isn't being misdirected. I get the impression you may not understand the use of "shared cache"... from what I recall from my play time with it many years ago, it is a way to cache hashed files into memory...

Or perhaps it's new in the 8.x world... or perhaps I was wrong. From memory, I thought that you were not allowed to append to datasets.

Clarify what you mean by from "DataStage Sequence". What exactly are you running and how exactly are you running it?

The product ships with a Migration Guide, everything you need to know should be in there.

Other than doing conventional updates, your non-plsql option (unless something new has come along I haven't heard of yet) is to leverage Oracle's MERGE functionality, which is basically their "upsert". Bulk load your changes as inserts into a work table and then issue the "merge"...