DSXchange

Well done on finding that; the error message was singularly unhelpful if that was indeed the cause.

Perhaps you could mark the thread as Resolved.

Transforms, which a simple review of the DataStage Designer Client Guide or Server Job Developer's Guide would have revealed to you, are pre-stored DataStage BASIC expressions that can be used in server and BASIC Transformer stage expressions. Transforms were, in versions of DataStage earlier than -...

5GiB isn't a lot, unless your server lacks "large file support". Contact your system administrator.

It's even different for different stages, and is sometimes configurable. That is, there is no single correct answer. Server jobs may use /tmp, the directory pointed to by TMPDIR environment variable, the directory pointed to by the TEMP environment variable, the directory referred to by UVTEMP in th...

In general it does not matter where in dsenv the TZ environment variable is set, except to note that, if it occurs more than once, the last one will win.

Not seen it before, but I don't use CASS on my side of the planet.

Have the CASS components been installed on your new server? Are there any rule sets that need to be provisioned?

In particular Splice() - or maybe Cats() - and Reuse(), as well as Convert().

Probably here, but also in the DataStage BASIC manuals.

I did.

What is the Oracle date picture? What is the DataStage date picture? They have to be functionally the same.

You can use dynamic array techniques to assemble the data, then convert the dynamic array delimiters to line terminators.

Write the routine so that it works backwards in the log until it finds a genuine starting event. Then work forwards from there.

That's interesting. I have never needed to do that. Which operating system are you using?

diamondabhi wrote:Do you have this function built in C++. Please share it if you can.

I don't.

Welcome aboard.

Download (for free) ETLstats from Kim Duke's website and adapt it. It does everything you ask and more.