Re: exec into question

[Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx>]

Hi tim

You can't do it this way - host variables are for values, not 
expressions - so you would have to specify the column name in the 
statement, not as part of a string - host variables are not for 
substitution into the statement.

Here's how it would look with a host variable:

testvalue = 100

exec sql SELEC count(*)
    into :cnt
    FROM claims
    where number = :testvalue

This is a better performer than this option - put the entire statement 
into a character variable and prepare a statement from that variable - 
then execute it. I don't want to make an example of that here, too easy 
to mislead you.

HTH
Vern

On 7/20/2018 11:17 AM, tim wrote:
> i have the following:
>
> exec sql SELECT count(*)
>      into :cnt
>      FROM claims;
>
>
> i would like to do the following (variable where build from field)
>
> wherestr = 'number = 100'
>
> exec sql SELECT count(*)
>      into :cnt
>      FROM claims
>      where :wherestr
>
>
> can this be done somehow?