DSXchange

Hi again everyone, I'm still trying to clean up this rogue job. Is there some way I can clear the log file other than from within DataStage Director. The log file is so huge it's making DS Director hang up. I've tried numerous things to kill this process, but it will not go away, and the log files a...

I've tried that, and it still indicates that it's running, Also when I right click on the job and select Monitor, the elapsed time is still increasing, so is it running or isn't it? HELP !!!!!

Please I need help ASAP. I cannot stop a server job that is running. I have had the DBA kill the oracle session, and I have submitted a stop from the DataStage Director, but nothing is stopping it. Our server administrator even re-booted our DataStage server, and it's still running. How do you stop ...

You can use KeyMgtGetNextValue or KeyMgtGetNextValueConcurrent depending on whether you have mutiple processes using the same sequence key, and then if you need to re-set the keys, you can use a command stage with the following command: UPDATE SDKSequences USING DICT VOC SET F1 = '1' WHERE @ID = 'yo...

This is how I used the variables in my Server Routine that Ray had mentioned. I hope it helps you. *** Arg1 *** Arg2 *** Arg3 *** Arg4 *** Arg5 *** Arg6 *** @USER0 = Returned 1st value *** @USER1 = Returned 2nd value *** @USER2 = Returned 3rd value *** @USER4 = Returned 4th value nDefault = 1 Begin ...

Can someone point me to the best tool (or maybe a free tool :lol: ) to use to connect a server job to a DB2 table on a mainframe. We actually have DS390, but we are looking at using server jobs to directly connect to the database. (We heard that using DB2 connect is faster than using the DS390 piece...

I am trying to find out what is more efficient, using hash tables as lookups or using OCI lookups. We have many dimension tables that have keys associated to them, and our fact tables need to retrieve these associated foreign keys. Some of our dimension tables have over 60 fields, that are all part ...

I know there must be some way to call a Stored Procedure from Oracle that returns a value, but I can't find it. Has anyone called stored procedures that returned values and if so, could you please tell me how to do this.

Thanks for any help.
Mona

Thanks for all the help. I used the @USER0 through @USER3 and it worked wonderfully.

Thanks again,
Mona

Thank you Craig and Michael for responding so fast. I appreciate it.

Mona

This may seem like a very basic question :oops: , but I am very new to DataStage and I am trying to create a New Server Routine that will allow me to return more than one value. I would be passing the routine 5 arguments and based on those, I want to return 4 new values which would be populated into...