I have a query.
SELECT col1 FROM table where Col2 in('A','B').
I declared a parameter in DSjob as indicator.
#indicator#.
SELECT col1 FROM table where Col2 in(#indicator#)
I want to pass 2values for this #indicator#.
The DD log shows
that job fails because of the bad query
SELECT col1 FROM table where Col2 in(A,B).
The job is not picking the the quotes. Though I gives the quotes.
Can I pass two values in one parameter or do I need give two parameters?.
Please suggest
Passing 2 values in one parameters
....
It's been such a long time since I've use the varible in the mdq, but from what I remember, I had problem with the quotes also.
First though, and with it being that long ago, this may not apply, I'd cut out one of the values from #indicator# to make sure that is exactly what the problem is, or maybe you've already tried that.
maybe try two quotes? Or use the encoding value for the quotes <<44>> (or whatever it is), like FTP URL encoding.
There may have been a trick to it, like put the quotes in some unlikley place, it's just been that long and at another job, so I can't even look it up. =(
First though, and with it being that long ago, this may not apply, I'd cut out one of the values from #indicator# to make sure that is exactly what the problem is, or maybe you've already tried that.
maybe try two quotes? Or use the encoding value for the quotes <<44>> (or whatever it is), like FTP URL encoding.
There may have been a trick to it, like put the quotes in some unlikley place, it's just been that long and at another job, so I can't even look it up. =(
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: