DSXchange

Come on... do you really need me to spell it out for you? It comes with a manual (look for the 'RAR command line syntax' section) and I'm sure your Googler ain't broke.

Click the link and all shall be revealed! [poof]

There's a link to his website in his 'signature', go there and then to his Tips page.

The people I show how to use 'Cleanup Resources' are not the same group of peoples I would want under the covers in the DS.TOOLS menu. Typically.

So, we're not talking about the normal DataStage "logs" viewed from the Director (which people have called "log files" around here) but rather a specific file created by the job? How very confusing...

I believe I too shall wait.

Specifically... YYYY-MM-DD HH24:MI:SS? All fields other than year always two digits? You can't do StringToDate() from a full Timestamp, you need to pass it just the date portion.

Do you know where they live and what to copy? Off the top of my head, they live in the RT_SCnnn directory with a pretty obvious name/extension but can't check at the moment.

$DSPROG? $DSHOME as a more generic first step, then perhaps "./bin/dssh" if the bin directory isn't part of your $PATH. Oh, and launching from there should start you off already logged to the UV account, IIRC.

what if the enviroment variable seemed ok. could it have another cause ? Well, 'not found' is not found so either that variable is wrong or no Oracle client is installed on the DataStage server. Parimi - did this work for you in the past but is now failing, or this is your first attempt and it's no...

Right, an IDENTITY column would make this whole conversation moot but unfortunately doesn't help answer the question that was asked. And before anyone says anything, no this is not something I know (yet) or I would be more helpful.

How long did you wait before you decided it was 'hung'? It's not the speediest dog in the kennel, so that's the first question in my mind. Also, does it hang for others as well, or just you?

'Alternately use Server jobs' how? This isn't a problem just for PX, hence the question.

In a Protected project? No. You'd have to unprotect the project and make every other job read-only for that.

I am able to zip a file from command line usind dos command but i am not able to zip using DataStage by using same command [sigh] Why not? What syntax did you use and happens when you use it, what error(s) do you get? :? Perhaps something like this will help in absense of the above information.