Probelm regarding Jobsequencer.

[arun_kumar]

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..

[chulett]

So... what exactly do you have in the Start Loop's Loop Definition From: property?

[arun_kumar]

So... what exactly do you have in the Start Loop's Loop Definition From: property?

from

#Exec_Loopvar.$CommandOutput#

step
-1
to
1

[ray.wurlod]

And what's the command?
Maybe you need DIGITS(CommandActivity.$CommandOutput) and/or to strip field marks from the command output.

[arun_kumar]

And what's the command?
Maybe you need DIGITS(CommandActivity.$CommandOutput) and/or to strip field marks from the command output. ...

command is cat

[ray.wurlod]

What, just cat? Not cat filename perhaps?

Maybe you need DIGITS(CommandActivity.$CommandOutput) and/or to strip field marks from the command output.

[chulett]

I'm sure you need DIGITS(CommandActivity.$CommandOutput) and/or to strip field marks from the command output.

[DSguru2B]

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.

[arun_kumar]

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

[ray.wurlod]

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).