DSXchange

It's still just a UNIX user and down at the O/S level it's no different from any other user - it's only DataStage in the engine's environment that gives it special privileges. Have you compared dsadm's .profile to some of the others to see if it has anything... 'special' in it that could be affectin...

NVL as in the Oracle function? Methinks you meant the NullToValue or even the NullToZero transform in DataStage.

Odd... more of a UNIX than DataStage issue, it seems. Have you pinged your SysAdmin about it?

Before and after you've switched to dsadm what is the value of $TZ?

If you're still having a problem with this, can you post the exact syntax you are using, please? You will need to CALL DBMS_SNAPSHOT blah-blah from what I recall, and possibly not include a semi-colon at the end. For sure you could use the Stored Procedure stage for this. We'd call things like that ...

Out of curiousity, what 7.x version are you running?

There was something like that when Service Pack 2 for XP rolled out years ago and there is a specific patch for that situation.

That's exactly what it uses - "regular" sql. So if you need to join tables in your query, go for it.

Search would have answered that for you. However...

viewtopic.php?t=116960

True. good point. If you have a version of Oracle that support both and see both a "lib" and a "lib32" directory out there, use the lib32 one unless you are one of the few peoples running a 64bit version of DataStage.

Something wrong with the other post where you asked this exact same question?

Sure but only in the "before/after SQL" tabs, not as source or target sql.

Some points... first off this is the 'entire contents of the dsenv file'. Notice the use of the code tags to preserve all that wondrous indenting Ascential spent many man-months perfecting. #################################################################### # # dsenv - DataStage environment file # ...

Give us some details to work with here. Stage, database, your sql, something to help us help you.

Have you escalated this to your official support provider yet?