DSXchange

Hi, I'm running a parllel job and it is taking most of server cpu and others are not able to work when my job is running. The job is doing a look up between 3 tables and using column generator and a funel stage and writing to a data set. I've tried running on 2 ,4 nodes the cpu is 100% for both of t...

Thanks

I did.Wait ...waits for job to complete.

jobstatus waits for job to complete and gives an exit code from job status.Hope it returns 1 which is not complete for other process except data stage.

Not sure how to use jobstatus which returns 0 to indicate job is completed.

Craig,

I have modified to dsjob -run -warn 0 -wait DS-PRJ sequencer

Is this enough or do we need some thing else.

Thanks Craig

How to add that wait to this script.What is command for that.please advice!

Thanks Craig

How to add that wait to this script.What is command for that.please advice!

Hi,

I have a batch script to call a sequencer.It is like :

cd \Ascential\DataStage\Engine\bin
dsjob -run -warn 0 DS-PRJ sequencer

This job has dependency job which should run after this job.

Does this script exits immediately or after successful completion of job.Please let me know

Thank You Chulett .

I was able to produce output file usinf field command. :D

That's my requirement :( Is there any method to select first word and then second word sepated by spaces. abc xyz input output should be: col1 col2 abc xyz And spaces between words are different for each words. I have tried chulett's suggestion and was able to create some records.Please advice!

chulett wrote:Use COUNT to get the number of spaces, add 1, then use FIELD to pull each of them from your space delimited string. Or skip the COUNT if it is always three (max). ...

Thank You

I will work using this and let you know how it goes

Hi, I have a situation where i need to separte words: Ex: My input data looks like CHICAGO CITY ABC XYZ A CNBC H. I need to separate one word char(30) into 3 words. col1,col2,col3 CITY,CHICAGO XYZ,ABC CNBC,A,H. The length of these characters in each line are different and they are not uniform throug...

chulett wrote:Please verify job type - Server as marked or PX based on the forum we are in? :? ...

I'm unable to delete this thread. :(

Hi, My data is: Parent data: Col1,Col2 1,111 1,222 1,333 1,444 Child data looks like: 1,111,S 1,111,B 1,222, 1,333,S 1,444,B I need to output like 1,222,S and B Missing 1,333,B is missing 1,444,S is missing I tried using 5 stage variables in transformer stage.But could not achive the correct output....

Hi, My data is: Parent data: Col1,Col2 1,111 1,222 1,333 1,444 Child data looks like: 1,111,S 1,111,B 1,222, 1,333,S 1,444,B I need to output like 1,222,S and B Missing 1,333,B is missing 1,444,S is missing I tried using 5 stage variables in transformer stage.But could not achive the correct output....

Thank you for all your responses.

I have tried giving quotes for parameter but got same error.

I have used wait for file activity and it is working fine.

shaonli:I will try your script and see how it goes.

have good week end !

Thanks