Probelm regarding Jobsequencer.
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 58
- Joined: Thu Feb 15, 2007 3:42 pm
Probelm regarding Jobsequencer.
Hi all,
I am working with startloop numeric type.In that it has to iterate for number oftimes. and acccording to the reqiurement it has to decrement by -1.it is getting input from one job in that job i had specifed only one column i am using that to as integer,and also tried as numeric too.
i am getting below error:-
Controller problem: Loop initial value not numeric (1) - cannot execute
please educate me regarding this issue.
Thanx in advance..
I am working with startloop numeric type.In that it has to iterate for number oftimes. and acccording to the reqiurement it has to decrement by -1.it is getting input from one job in that job i had specifed only one column i am using that to as integer,and also tried as numeric too.
i am getting below error:-
Controller problem: Loop initial value not numeric (1) - cannot execute
please educate me regarding this issue.
Thanx in advance..
Arunkumar..
-
- Participant
- Posts: 58
- Joined: Thu Feb 15, 2007 3:42 pm
Problem with job sequencer
chulett wrote:So... what exactly do you have in the Start Loop's Loop Definition From: property?
from
#Exec_Loopvar.$CommandOutput#
step
-1
to
1
Arunkumar..
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 58
- Joined: Thu Feb 15, 2007 3:42 pm
Problem with job sequencer
ray.wurlod wrote:And what's the command?
Maybe you need DIGITS(CommandActivity.$CommandOutput) and/or to strip field marks from the command output. ...
command is cat
Arunkumar..
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 58
- Joined: Thu Feb 15, 2007 3:42 pm
Regarding Job sequencer
DSguru2B wrote:To add to the explanation, the value contains a carrige return which DataStage engine changes to a field marker "@FM". DIGITS() will extract just the numeric field, which is why it is suggested.
Hi all,
THanks for your nice response.But Here i am using excute command stage commnd tab i am specifing "cat" and in param place i am specifing "filename".So in this text box it wont allow us to specify the above command.
where i have to specify the command.
Please educate me regarding this issue.
Thanx in advance
Arunkumar..
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Downstream of the Execute Command activity - on any activity (Job Activity, Routine Activity, etc.) when you are entering a job parameter value you can nominate one of the upstream activity variables - in this case the output from your Execute Command activity.
Assuming you're on version 7.5, you can use this activity variable in any expression. If DIGITS (a DS Transform) is not available, use Convert() to strip out the field mark and extraneous white space character(s).
Assuming you're on version 7.5, you can use this activity variable in any expression. If DIGITS (a DS Transform) is not available, use Convert() to strip out the field mark and extraneous white space character(s).
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.