DSXchange

Each user's .profile can set that, as can DataStage's dsenv file.

I don't believe that method of releasing job locks is still valid in the 8.x release. Could be wrong, someone will know for certain.

I was wondering if that was what was going on but couldn't find that level of detail in the docs. Is this just something that you know, having been involved with The Creators?

Oracle Timestamp data types are not supported but you can generate your own sql and use TO_TIMESTAMP() rather than the TO_DATE() the stage will automatically generate for you.

Where does the "DSJE_BADSTATE Compilation error" part come in?

If you have DataStage, you have a full suite of documentation - and it would be a violation of one's license agreement to distribute them. You've also hijacked an old post, which is frowned upon here. Start a new post, let us know the particulars of your issue and we'll see about getting it sorted o...

Me, I would script that. I can't check now but the older FTP stages had 'telnet before/after' options which could be used for something like this. Does the Enterprise stage support anything of this nature?

SURA, I appreciate you cleaning up your post as I don't have admin privs in this forum but you should have left your actual reply in place. Please edit your post again and add that back in.

Support? I imagine that if anyone had anything else to add, they would have done so by now.

SURA, why in the blue blazes do you continue to feel the need to quote an entire post just to reply? Learn to use the perfectly lovely Reply to topic link please.

That was already posted. Odd, they seem to point at each other, seems like we are missing what actually caused the warning that brought the job down.

Was hoping that was obvious.

Yes, "abc" is your sequence name in the Key Mgt routines as both Ray and I have pointed out to you. Now, it may match the name of the target table you are using the generated key for but that's hardly necessary. And if you have multiple jobs targeting the same table then they should all u...

In your searching, did you run across references to this IBM technote?

OK... so what was the warning that triggered the abort?