Re: select into with case condition

[Robert Rogerson <rogersonra@xxxxxxxxx>]

I'm thinking that sql doesn't know about the rpg variable  parm (since 
the op coded it is as host variable).

So I think  the code would have to be

If parm = '1';

  select column1, column2

      into :hostvar1, :hostvar2

Else;

  select column1, column2

      into :hostvar3, :hostvar4

Endif;

Rob

On 2/27/2019 2:39 PM, Jay Vaughn wrote:
> what is the proper method/syntax (if any) to allow something like the
> following...?
>
>
> select column1
>            ,column2
> into...
> case when :parm = '1'
>           then :hostvar1
>                   ,:hostvar2
>            else :hostvar3
>                   ,:hostvar4
> end
> from mytable
> where this = that;
>
> tia,
>
> jay