DSXchange

Hi,
I would like to know, how any static data file used in reference be updated in DataStage? Does DS have any mechanism to update, or any third party tool to be used for such updates. Any directions on this, is appreciated. Thanks in advance, Vijay

ray.wurlod wrote:A job sequence can, of course, contain just a single Job Activity. The run method of the job can be set to "reset if required, then run". Of course, the automatic restart capabilities of that sequen ...

Ray,
Thanks for the response...But I couldonly read part of your response !?!?

A sequence can be made restartable, but I doubt if a single job can be restartable, if it aborts mid-way. Again it depends on what your job is performing....Has it done what you want it to do... If your load has failed at a certain point, you could run your job again giving @INPUTROW > xxx as a con...

You will have to include your Job in a JobSequence(create one) and then in the Job Properties of the Job Sequence you will find a property "Add checkpoints so sequence is restartable on failure". Check that and also explore about it in the manual. That is the starting point. Thanks Kris, ...

I read thru the manual, but haven't gotten any conclusive answer to this: I have a job with few stages in it. It processes quite a large volume of records. If the job fails after some interval, is there a feature in Datastage that would allow re-startability from 'that' point , and not from the begi...

I didn't say for you to try to 'update Client License details'. I believe you'll need to reinstall the client software from the original media, during which you'll supply the new credentials you have. Just install it right over your current installation, you won't lose any customizations you've mad...

I guess I don't need to re-install the Client Components again w/ the new License details. Actually, that's exactly what you need to do. But I'm getting error when trying to update Client License details..[Error calling subroutine: DSR_PROJECT (Action=33); check DataStage is set up correctly in pro...

A Question: We had a trial license[xxxxx-DSDES] that expired a while ago and now have a different license[yyyyy-DSDES]. How do I update the Client License ? I guess I don't need to re-install the Client Components again w/ the new License details. But at the same time, it isn't allowing to upgrade/u...

Hi All, My requirement is source is oci and looks empno ename dept sal 1 A 1 5 2 B 1 10 3 C 2 10 4 D 3 5 5 E 2 10 I need to get total sal by grouping dept using aggregator and my data should look like empno ename dept sal 1 A 1 15 2 B 1 15 3 C 2 20 4 D 3 5 5 E 2 20 Any suggestions please Thanks in ...

That depends on how you trigger you job. If you want to execute jobs parallaly, dont wait for it to finish before other job starts. That's my intent., to run few jobs parallel[y] but with Batch Sequencer, it doesn't allow that way. A Job sequencer, does help though, but I'm having difficulties pass...

Hi, Whenever i try compiling a parallel job after it aborts due to some reason i get a message as below Cannot get exclusive access to executable file for job Jbname Tried clean up resources option in the director , but it does not have any locks or resources to release. Please let me know the solu...

Hi, Regarding the sequence issue you can have an additional job parameter or use the invocation id if you use a multi instance job to diferentiate between file names. Regarding the other issues it seems sometihng is killing your jobs and or the system is overloaded at times. Sometimes there are pro...

Hi, I have a stream of 3 jobs and I'm sequencing it. The Output from Job#1 is Input to Job#2 and Job#3 and I want the Output of Job#1 to end with a type based on the run. How do I establish this. I included filename#XX# as the filename, and XX is prompt in Job Sequencer, but in the following jobs, t...

s_boyapati wrote:Hi Guys,

I got certified with 94% score.

Sree

Congratulations...Please post your experience [test] as well your preparation methodology., when you get time. Thx

A Question: If the field is 50 byte STATE code,and the value takes just 15bytes. Would this csv formatting, eliminate the 'white' space. ie. would the output be like #1 or #2 #1 1111 , "New York" , USA #2 1111,New York,USA Thanks, -V Hi Craig, I got it!! But i am facing data formatting iss...