DSXchange

In the ExecCommand Stage of Sequenece, in the command tab I have to excute this command as below. but I want to parametrize the "/home/datastage/run/" part as this will vary from dev to UAT enviroment. Please advice.

/home/datastage/run/copy.sh

Please advise how to import the stored procedure defintion from Oracle Database? Does it also requires to set up an ODBC data source for Oracle to import Oracle store procedure? Thanks Dhawan

Can you please shed more light on this and 'stream'?

chulett wrote:Not unless you can establish some kind of process break between them and thus link them together in one 'stream'. ...

Reading the queue in the browse mode will levae the message in the queue and resultss in more mainteance issues. How can we implement TXN control if any in this case?

ray.wurlod wrote:Apparently you can browse the MQ Series queue rather than destructively reading it. ...

My requirement is:

To read from MQ, do database call based on message and then write to a file. How can I maintain a transaction control in this? That means teh message should not destruct until and unless is written to file and job finished successfully.

We cannot specify the order in the designer at all?

chulett wrote:Three jobs, run in a serial fashion via a Sequence job. ...

I have three flows in a job: 1) MQ1->Transformer1->Sequential file1 2) MQ2->Transformer2->Sequential file2 3) MQ3->Transformer2->Sequential file3 My requirement is run 1), 2) and 3) in the sequential order. Run 1) and go to 2) only if 1) finishes and go to 3), only when 1) and 2) finishes. If they f...

Craig, thank you. It worked!!

chulett wrote:Field marks in the output need to be removed. Your Custom Conditional expression should be:

Execute_Command_7.$CommandOutput<1>=1

-or-

EReplace(Execute_Command_7.$CommandOutput,@FM,"")=1

This is the output that i see in Director: Note one space line after 1. -------- Reply=0 Output from command ====> 1 ------ And the Custom Conditional expression is: Execute_Command_7.$CommandOutput=1 When I execute this never gets true to run the 2nd job. Please advice That's just standard UNIX / s...

Thanks. I will try this. Where can I find the documentation of these statuses? That will be helpful for me. Regards to everyone. Give that boy a cee-gar! :wink: ReturnValue is the status of the command and zero indicates it ran without error. CommandOutput would capture whatever the command echo'd u...

Thanks. I will try this. Where can I find the documentation of these statuses? That will be helpful for me. Regards to everyone. Give that boy a cee-gar! :wink: ReturnValue is the status of the command and zero indicates it ran without error. CommandOutput would capture whatever the command echo'd u...

I have used the execute command activity to run the shell script like: cat /user/local/tmp/count.txt count.txt can have values of 1 or 0 Then I put two Return value conditional expression = 1 and Return value conditional expression = 0 But it never goes to this condition 1 ie when the value in the c...

Thanks JoshGeorge and Ray!

ray.wurlod wrote:In short, the answer to the second question is "no". ...

Thanks Ray. But is it possible to store the value in the variable in the first job and then use that in the cutom trigger of the activity job to run the second job or not. Welcome aboard. Run the first job. Then have an Execute Command activity read (cat) the file. Capture the output and extract the...

Hi All, I have two parallel jobs. First job that returns 0 or !=0 value in the file. The second job creates a data file. What I am looking is to put a job sequenece with the below logic: If the output data value of first job is 0, run the second job otherwise send an email. Please suggest how to wri...