equal to symbol(=) not taken as a job parameter

mouni · Post by **mouni** » Wed Jan 21, 2009 1:26 am

when a job parameter has a "=" value , the job throws a warning
as this

Invalid argvalue `error_cod=----|FILENAME= Test_20080801.dat', missing =.

Inside the transformer , we are splitting the job parameter with the delimiter as "|"

How do i remove this warning.

ray.wurlod · Post by **ray.wurlod** » Wed Jan 21, 2009 1:39 am

How are you doing the splitting?

mouni · Post by **mouni** » Wed Jan 21, 2009 2:08 am

like this Field(error_cod,'|',1)

ray.wurlod · Post by **ray.wurlod** » Wed Jan 21, 2009 5:26 am

What is the name of the variable that contains 'error_cod=----|FILENAME= Test_20080801.dat' ?

mouni · Post by **mouni** » Wed Jan 21, 2009 7:56 am

error_cod is the job parameter.

A stage variable called COD_ERROR does this function "Field(error_cod,'|',1)

The value passed to the error_cod='ERR-0020|FILENAME=Test_20080801.dat'

mouni · Post by **mouni** » Wed Jan 21, 2009 11:18 am

any thoughts on this ?

ray.wurlod · Post by **ray.wurlod** » Wed Jan 21, 2009 12:04 pm

So, we're not permitted to sleep?

Given that the job parameter error_code is populated as you say:
Field(error_cod, "|", 1, 1) will return error_cod=----
Field(error_cod, "|", 2, 1) will return FILENAME= Test_20080801.dat

What are you doing with the stage variable COD_ERROR ?

kduke · Post by **kduke** » Wed Jan 21, 2009 10:52 pm

There are lots of special characters which should be avoided in parameter values like = and '. You need to write job control if have to have these values passed in.

kandyshandy · Post by **kandyshandy** » Thu Jan 22, 2009 9:18 am

I am not sure about this Kim's comment. I have passed an entire WHERE clause as a parameter with mutiple '=' and it worked

kduke · Post by **kduke** » Thu Jan 22, 2009 2:54 pm

You can pass ' and = in job control. I doubt it would work in shell script.