DSXchange

So Ray was the only person that replied, eh? Nice.

ds_loadlibrary: error in dlopen of oraoci9.so - libclntsh.so.10.1: cannot open shared object file: No such file or directory At this point, that is your problem. It indicates that your LD_LIBRARY_PATH is not setup correctly in the dsenv file. Or you may need a soft link between client versions / lo...

Fix your call to the the User Defined routine called "SystemTimeStamp".

Yes. If you want to allow warnings to be ok.

When you reset the job it will add an entry labelled 'From previous run...', look for that.

That trigger means the next job only runs when the previous job finishes with warnings. A successful run will not trigger the next job. You need to check for RUNOK or RUNWARN.

Nope. Reset the aborted job and look for the contents of a 'From previous run...' log entry.

I'm sorry but what does this have to do with DataStage? Talk to whomever you work with that can help you with the model, a SME, Architect or Data Modeler or the like. However, at a very high level any 'fact' will be at the center of the spiderweb and dimensions are the outliers circling it. They sho...

Next time, please just do this - one post asking your question in the proper forum rather than adding it to every post you could find that was slightly related.

ps. I've deleted all of your duplicate posts.

What they do is pretty self-evident from their names and the behaviour that you've seen. The former forces the use of the 'default' value you defined in the controlled job at design time, the latter lets you override that at run time. You, however, have an entirely different problem. Do an exact sea...

Sorry but don't you have people with UNIX skills where you work you can talk to? This really isn't a "teach you UNIX" forum, I'm afraid.

You have to own a file in order to be able to chmod it.

... and the slow spiral off topic picks up speed.

Talk to someone you work with that can help - DBA, Architect, whomever.

Google can also help as well. For example, a search for "oracle cast clob to varchar2" returns many results, including this one from the perennial favorite Ask Tom.

How? Share your secret with us.

I'm not sure what is making people think the email server is required, but then the original post has been edited. I've never seen a UNIX server that needed it. [shrug] You get something in dead.letter when it is undeliverable for whatever reason. I'm assuming here it is because you're not getting t...