Job Running Logic

[balajisr]

As chullet suggested you just need to specify

Code: Select all

COUNT_VALUE.$CommandOutput<1> >0

Where COUNT_VALUE is the name of the exec command activity in your job sequence.

In the exec command activity just specify cat command.

Please do not quote the entire post while replying. It wastes a lot of space and makes the post difficult to read. Quote only if it is necessary.

[pravin1581]

As chullet suggested you just need to specify

Code: Select all

COUNT_VALUE.$CommandOutput<1> >0

Where COUNT_VALUE is the name of the exec command activity in your job sequence.

In the exec command activity just specify cat command.

Please do not quote the entire post while replying. It wastes a lot of space and makes the post difficult to read. Quote only if it is necessary.

Thanks for all the replies, when I parameterize the file path the cat does not work.The job itself is getting aborted.The log shows that cat cannot open the file.The cat command has been modified as :

Code: Select all

        cat file_pathfile_name

where file_path is the parameter specifying path of the file.

[Minhajuddin]

you can't pass parameters in the command textbox of Execute Command activity. If you want to pass parameters you need to put them in the parameters textbox of the execute command activity.

[pravin1581]

you can't pass parameters in the command textbox of Execute Command activity. If you want to pass parameters you need to put them in the parameters textbox of the execute command activity.

Thanks ,I have done the same. But how will the cat command get its file path. I am not supposed to hardcode it.

[Minhajuddin]

Code your Execute command activity this way:

Code: Select all

Command: cat 
Parameters: #file_pathfile_name#

[pravin1581]

Code your Execute command activity this way:

Code: Select all

Command: cat 
Parameters: #file_pathfile_name#

Thanks it worked , I would like to know what the Convert function is doin here, because only it worked and not the ActivityName.$Command output.
thanks for all the suggestions.

[ray.wurlod]

Line terminators are converted to field marks (@FM). The Convert() function removes them. When Craig suggested the <1> notation he was attempting to do the same thing, but one can never be totally sure that the result is in the first field (line) of output, which is why I prefer the Convert() approach.

[pravin1581]

Line terminators are converted to field marks (@FM). The Convert() function removes them. When Craig suggested the <1> notation he was attempting to do the same thing, but one can never be totally sure that the result is in the first field (line) of output, which is why I prefer the Convert() approach.

When we tried using the $CommandOutput function as suggested by Craig it gave reverse results i.e. running for the 0 count and not running when count is 0, even though the expressions used in the respective links were correct but we did not use that <1> notation, what does that notation signify.

Thanks for the reply.

[chulett]

What is returned is a dynamic array, and that notation says you want to check only the first element in the array.

I agree with your point, Ray, and have used both notations. I prefer the one I posted and, when I use it, I ensure what I'm after is always in the first element. If at all possible.

[pravin1581]

What is returned is a dynamic array, and that notation says you want to check only the first element in the array.

I agree with your point, Ray, and have used both notations. I prefer the one I posted and, when I use it, I ensure what I'm after is always in the first element. If at all possible.

But when I use it in the expression along with the notation it gives me a syntax error.

[ray.wurlod]

There must be no space between the activity variable name ($CommandOutput) and the "<" character.