DSXchange

And in my experience I've found them to be quite resilient and really only saw "corruption" for issues like (lack of) disk space, going over the dreaded 2GB barrier with 32bit addressing or by writing funky data to them. Otherwise, solid. Like I said, different strokes.

Post your actual unedited error message.

When you create the hashed file/s you are better off deleting and recreating them (if possible) for this (amongst other) reason. Whereas in my experience, deleting and recreating them each time has been at the root of this issue. I tended to stick with "Clear" unless I had a good reason t...

daignault wrote:Backing up a Type30 causes the ".Type30" to go missing.

That would depend entirely on how one backs it up, yes?

My first question (as one that is not a DB2'er) would be - what does a DB2 date need to look like? And what DB2 stage are you using?

I would look into setting up the data so you could then perform a horizontal pivot. For example:

1,gg,3 -> 1,gg,3,gg,3,gg,3
2,hh,2 -> 2,hh,2,hh,2

Set up the max number of columns and then pivot the result.

From what I recall, they would need to be System DSNs.

There should be a NullToEmpty() transform and perhaps a NullToValue() one as well, wrap each element that could be null with one. An empty string will work fine whereas a null will not, that or another value that won't show up on its lonesome in your data - I've used a '?' or a '*' in the past to ma...

Post the actual, unedited errors.

Do we get any clues as to the nature of the problem?

... make sure you use one of the wait options, "-jobstatus" would be preferred here in my humble opinion.

The compiler is dscc and an exact search here for that will turn up the syntax and issues people have seen with it.

In your version they are just UNIX users, so remove the user from the DataStage server.

After SQL would be too late.

You need to look into the following APT variables:

$APT_ORAUPSERT_COMMIT_TIME_INTERVAL
$APT_ORAUPSERT_COMMIT_ROW_INTERVAL

Read the definition of that particular function, it is not for gathering log information but rather for checking the return value of other function calls.

What exactly are you trying to accomplish? If you are trying to retrieve information from job logs, there are other specific functions for that.