Re: SQL select using where in

[Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx>]

Roger

I think that the resulting WHERE clause is like this -

Where pypmtt in '(''CK'', ''BT'')'

That's definitely not what you want, I bet. This is what is described in 
the manual as

   expression IN expression

and is the same as

   expression = expression

I think you need to create the SQL statement as a string, then prepare it.

The docs seems to suggest that parameter markers (question marks) are 
not allowed in the parentheses after the IN. I'm not sure, but it looks 
that way.

HTH
Vern

On 2/12/2013 12:50 PM, Rettig, Roger wrote:
> I have a SQL clause embedded in a RPG program.  The statement inserts
> records directly into a file.  In the where clause, I have an 'in'
> statement using a variable:
>
> Where pypmtt in :CheckType
>
> using debug the value of checktype = ('CK', 'BT').  This inserts 0 records.
>   If I hardcode and replace checktype with ('CK', 'BT'), the program inserts
> the the correct records.  There are other variables in the select statement
> that are not causing issues.
> What am I doing wrong?