Search found 154 matches

by dspxguy
Mon Jul 09, 2007 11:38 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Sequencer
Replies: 26
Views: 6605

You don't need the sh here. Just execute test -f /home/edw/delstatus.txt && rm -f /home/edw/delstatus.txt You should be fine. (Parameterize as required) Thankyou very much all of you ....it works. What if I also had a directory and it was in the same path folder in which I have the delstatu...
by dspxguy
Mon Jul 09, 2007 11:07 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Sequencer
Replies: 26
Views: 6605

I have one command activity stage and one job activity. Just want to delete status file before the job activity stage runs. the message in director is seq_delstatfile..JobControl (@Exec_Comm): Executed: 'sh' test -f /home/edw/delstatus.txt && rm -f /home/edw/delstatus.txt Reply=126 Output fr...
by dspxguy
Mon Jul 09, 2007 10:50 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Sequencer
Replies: 26
Views: 6605

chulett wrote:Post your command syntax, not Ray's. And I mean the actual 'Executed command' from the same log entry you posted the output from.

Command:

'sh'


Parameters:

test -f #DEL_FILE# && rm -f #DEL_FILE#

DEL_FILE is my job parameter with path to the status.txt file in the unix directory
by dspxguy
Mon Jul 09, 2007 10:29 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Sequencer
Replies: 26
Views: 6605

How about an ExecuteCommand (do not skip) activity at the front of the job sequence? test -f #pathname# && rm -f #pathname# ... Hi all, When trying to delete my status file using the above syntax I am getting this info message in director Reply=126 Output from command ====> test: /usr/bin/t...
by dspxguy
Mon Jul 02, 2007 9:43 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Sequencer
Replies: 26
Views: 6605

How about an ExecuteCommand (do not skip) activity at the front of the job sequence? test -f #pathname# && rm -f #pathname# ... Thanks for the post Ray.. rm -fr would remove all files in a directory and the directory itself, what does rm -f do? I am asking this because I have a temp directo...
by dspxguy
Mon Jul 02, 2007 8:49 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Sequencer
Replies: 26
Views: 6605

Thanks Chulett and Narasimha.. will I be using a routine "GetJobStats" ? and do I have to create routine for all jobs in my Job sequence ? I am already using a routine "failureforce" after each job aborts, so I need to add another routine activity stage after "forcefailure&q...
by dspxguy
Fri Jun 29, 2007 2:39 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Sequencer
Replies: 26
Views: 6605

Sequencer

If my job sequencer aborts for any reason then the temporary status file created has to be deleted otherwise the sequencer aborts again and again. i have jobs in my sequencer and using routine activity stage for jobaudit, so whenever the sequencer fails, a temp status file has to be deleted otherwis...
by dspxguy
Tue Jun 26, 2007 4:15 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: execute command stage
Replies: 10
Views: 3412

chulett wrote:That example was Windows specific. Try using plain old 'sh' instead. ...


It worked, Thanks Michael and Chulett..
by dspxguy
Tue Jun 26, 2007 3:45 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: execute command stage
Replies: 10
Views: 3412

You can call the command from within a shell. The input box that takes in the command would execute a command to create a new instance of a shell and the parameters would be the path of the command that you want to run. I do this in windows. For example if I want to execute c:\var_path\mike.exe whe...
by dspxguy
Tue Jun 26, 2007 1:02 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: execute command stage
Replies: 10
Views: 3412

chulett wrote::? Just enclose the parameter name in pound/hash/# marks like usual.
I am getting this error "executable path cannot contain parameters"


In the command field I want to parametrize the path ?
Any advice would be appreciated.
Thanks
by dspxguy
Mon Jun 25, 2007 10:42 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: After Job Sub rouitne
Replies: 3
Views: 978

Thanks for the reply Andrw

Can you please elaborate more on setting the user status..

Cheers
by dspxguy
Mon Jun 25, 2007 9:59 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: After Job Sub rouitne
Replies: 3
Views: 978

After Job Sub rouitne

I have a job in the sequence which uses a after job sub routine to kick of a shell script which does an insertion in a table used by another job.

How can I get the status of the script using a routine activity stage (whether it ran successfully or not?)

Thanks in advance.
by dspxguy
Mon Jun 25, 2007 9:44 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: execute command stage
Replies: 10
Views: 3412

execute command stage

I am calling a script in the execute command stage and would like to parameterize the path of the shell script.
what is the syntax for it?

Thanks
by dspxguy
Thu Jun 14, 2007 2:01 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: job sequence
Replies: 16
Views: 5244

OK conditional trigger in COMMAND EXEC ACTIVITY .