Reading a file in Sequence

[G SHIVARANJANI]

hi,

How can we read anumeric value in a file which is the out put of job1 and has to be passed as a parameter to another job.

I tried to use execute command stage with
cat <filename>

but it is giving an error as
Controller problem: value not numeric (7) - cannot execute


tried with NUM as well but check if it is numeric or not...
please suggest

[jdmiceli]

Does the sequential file you wrote to have headers in it? If so, then you need to skip the first line (or stop the headers from being created). Also, is that value the only value in the file or are there more pieces of information. One more thing to consider is how your code that creates this file is handling NULLS. If it doesn't replace a NULL with zero, then you will continue to see the error.

Hopefully something in that hodgepodge helps!

[tom]

Hi ranjini,

In the excecute command activity stage

in command give value as

sh -c

and in parameters give value as

"cat filename"

pass this value as a parameter to the next jobactivity stage for the desired job using the code .

Field(EXC_Read_Seqid.$CommandOutput, @FM,1)

HTH
tom

[G SHIVARANJANI]

Thanks a lot for the reply

This resolved my issue..

Hi ranjini,

In the excecute command activity stage

in command give value as

sh -c

and in parameters give value as

"cat filename"

pass this value as a parameter to the next jobactivity stage for the desired job using the code .

Field(EXC_Read_Seqid.$CommandOutput, @FM,1)

HTH
tom

[chulett]

Field(EXC_Read_Seqid.$CommandOutput, @FM,1)

This was the important bit, the need to remove any Field Marks from the output of the cat command. You could also have used Convert or EReplace to accomplish the same thing if you needed to remove multiple occurances:

Code: Select all

Convert(@FM,"",EXC_Read_Seqid.$CommandOutput)

[ray.wurlod]

Or, indeed, a DIGITS Transform.