Search found 76 matches

by agathaeleanor
Mon Jul 23, 2012 3:45 am
Forum: General
Topic: Schedule job in yearly basis
Replies: 2
Views: 1535

Schedule job in yearly basis

Hi all Gurus,
I am not sure if this has asked before in the forum. I would like to know if we can schedule a job running in yearly basis?

thanks in advance.
by agathaeleanor
Wed Nov 23, 2011 1:23 am
Forum: General
Topic: Pass in parameter to ExecCommand stage
Replies: 22
Views: 9642

issue resolved with,
command property: exec
parameter property: <script name> <parameter>
by agathaeleanor
Mon Nov 14, 2011 6:27 am
Forum: General
Topic: Pass in parameter to ExecCommand stage
Replies: 22
Views: 9642

thanks chulett for your reply. This error states that your path to the script is invalid; either it does not exist, is misspelled or you don't have the proper permissions... and I don't see how adding the "dot space" to the beginning makes it find it. somehow, the job still able to execute...
by agathaeleanor
Thu Nov 10, 2011 2:52 am
Forum: General
Topic: Pass in parameter to ExecCommand stage
Replies: 22
Views: 9642

It is still same, no value being passed to shell script.

I am wondering if the command stage supports pass-in parameter?
by agathaeleanor
Thu Nov 10, 2011 1:13 am
Forum: General
Topic: Pass in parameter to ExecCommand stage
Replies: 22
Views: 9642

basically nothing has passed down to the shell script :(
by agathaeleanor
Thu Nov 10, 2011 1:04 am
Forum: General
Topic: Pass in parameter to ExecCommand stage
Replies: 22
Views: 9642

Job logged,


JobControl (@Execute_Command): Executed: . /u01/dstage/hpbdev/Sequential/FI/Scripts/RemoveTrailer_FI_MOH_Budget.sh "I"
Reply=0
Output from command ====>

version is
by agathaeleanor
Thu Nov 10, 2011 12:35 am
Forum: General
Topic: Pass in parameter to ExecCommand stage
Replies: 22
Views: 9642

after removing print, job logged


JobControl (@Execute_Command): Executed: . /u01/dstage/hpbdev/Sequential/FI/Scripts/RemoveTrailer_FI_MOH_Budget.sh "M"
Reply=0
Output from command ====>
version is
by agathaeleanor
Thu Nov 10, 2011 12:03 am
Forum: General
Topic: Pass in parameter to ExecCommand stage
Replies: 22
Views: 9642

Hi Craig, After removing the dot and the space, it hits error as below. JobControl (@Execute_Command): Executed: /u01/dstage/hpbdev/Sequential/FI/Scripts/RemoveTrailer_FI_MOH_Budget.sh "I" Reply=1 Output from command ====> SH: /u01/dstage/hpbdev/Sequential/FI/Scripts/RemoveTrailer_FI_MOH_B...
by agathaeleanor
Wed Nov 09, 2011 11:42 pm
Forum: General
Topic: Pass in parameter to ExecCommand stage
Replies: 22
Views: 9642

I'm curious why you have a "dot space" at the beginning of the command? Does the behaviour change if you remove that? At first it looks weird to me as well, but when it get removed, the log says, JobControl (@Execute_Command): Executed: ./u01/dstage/hpbdev/Sequential/FI/Scripts/RemoveTrai...
by agathaeleanor
Wed Nov 09, 2011 8:15 pm
Forum: General
Topic: Pass in parameter to ExecCommand stage
Replies: 22
Views: 9642

VER_ID is select from the list of parameter.

I am wondering why VER_ID is not being passed down to shell script.

Any workaround? Thanks.
by agathaeleanor
Wed Nov 09, 2011 7:47 pm
Forum: General
Topic: Pass in parameter to ExecCommand stage
Replies: 22
Views: 9642

Thanks all for your response. I tried execute the shell script(without being called by datastage) it works. ./RemoveTrailer_FI_MOH_Budget.sh #VER_ID# In the property of execute command stage, command: . /u01/dstage/hpbdev/Sequential/FI/Scripts/RemoveTrailer_FI_MOH_Budget.sh Parameters: #VER_ID# Log ...
by agathaeleanor
Wed Nov 09, 2011 1:36 am
Forum: General
Topic: Pass in parameter to ExecCommand stage
Replies: 22
Views: 9642

Pass in parameter to ExecCommand stage

Hi All, I am trying to pass in a parameter to execute command stage, and based on the passed-in value, the shell script could execute accordingly. However, the pass-in value is not able to pass down to the shell script. As i performed echo from the shell script, the log shown that the value being pa...
by agathaeleanor
Thu Sep 29, 2011 1:37 am
Forum: General
Topic: To read one line of record from a file
Replies: 2
Views: 1605

Thanks ray. It works :)
by agathaeleanor
Thu Sep 29, 2011 12:23 am
Forum: General
Topic: To read one line of record from a file
Replies: 2
Views: 1605

To read one line of record from a file

Hi all, I have a file (email.txt) which stores user emails and the subject area. Format: email1@domain,email2@domain,email3@domain|subject1 email21@domain|subject2 email31@domain,email32@domain|subject3 I created a sequencer contains execute_command(cat) --> UVA --> Parallel Job --> Notification_act...
by agathaeleanor
Fri Aug 26, 2011 2:47 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Parallel job reports failure (code 139)
Replies: 1
Views: 1524

Parallel job reports failure (code 139)

Hi all experts, I have a parallel job running perfectly fine in SIT environment. But it never run success in Production due to the error 'Parallel job reports failure (code 139)' Before this, we have tried to recompile job, recreate job, it doesnt work out. Just a while ago, i changed the setting of...