Page 1 of 1
equal to symbol(=) not taken as a job parameter
Posted: Wed Jan 21, 2009 1:26 am
by mouni
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.
Posted: Wed Jan 21, 2009 1:39 am
by ray.wurlod
How are you doing the splitting?
Posted: Wed Jan 21, 2009 2:08 am
by mouni
like this Field(error_cod,'|',1)
Posted: Wed Jan 21, 2009 5:26 am
by ray.wurlod
What is the name of the variable that contains 'error_cod=----|FILENAME= Test_20080801.dat' ?
Posted: Wed Jan 21, 2009 7:56 am
by mouni
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'
Posted: Wed Jan 21, 2009 11:18 am
by mouni
any thoughts on this ?
Posted: Wed Jan 21, 2009 12:04 pm
by ray.wurlod
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 ?
Posted: Wed Jan 21, 2009 10:52 pm
by kduke
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.
Posted: Thu Jan 22, 2009 9:18 am
by kandyshandy
I am not sure about this Kim's comment. I have passed an entire WHERE clause as a parameter with mutiple '=' and it worked
Posted: Thu Jan 22, 2009 2:54 pm
by kduke
You can pass ' and = in job control. I doubt it would work in shell script.