DSXchange

Rajiivnb, use this routine instead and see what results you get. It works at my end Cmd = 'SETFILE ' : hshdflpth : ' ' : 'hsdfile' :' OVERWRITING ' PERFORM Cmd PERFORM 'COUNT ' : 'hsdfile' Ans = @SYSTEM.RETURN.CODE @SYSTEM.RETURN.CODE = 0 All i did was to add "@SYSTEM.RETURN.CODE = 0" at the end to ...

These are not C routines. These are Orchestrate C++ API's.

There is no type as "Control". The valid options are "INFO | WARNING | FATAL | REJECT | STARTED | RESET | BATCH".

Its not there. Search for DSSetUserStatus() in DataStage help index. Also for DSGetJobInfo().

And I was correct in my hunch. I ran a CLEAR.FILE before running the Cmd in the OP's routine. It returned zero with "Test Completed" message. :D
They did'nt change the test bed, atleast we know that for sure.

Or possible the hashed file in one environment is empty.

And the third one is not for all, right

Very useful information Ray. Very useful. I was breaking my head trying to get to the bottom of this.
I still dont get one thing, how come it works in one environment for the OP and not in another ?

You remember stuff from nineteen mumble mumble

narasimha wrote:If you had made that offer before, you would have got a quicker solution. Just kiddin

101 %

Your most welcome

Parameter pompt can be as meaningful as you want. Heck you can write a short story there. When you run your job from designer or director, it will pull up the prompt and not the actual parameter name. So make sure you have meaningful entry in the prompt. When jobs are run from command line or schedu...

I say stick to decimal. If you want the "after decimal digits" to be preserved after a mathamatical operation, you dont have to use FMT and ICONV/OCONV functions to maintain its format.

I havent heard of any command line tool. DataStage admin is kinda like that tool. But the thing is you have to go to individual project, in your case 150+, and change it there. You can create a script of your own that does this for you. You can make the DSParams backup and rename the original one, c...

santoshkumar wrote:Am I commiting suicide !!

Not if your fact tables are in tera bytes