Re: Using host variable in embedded sql

[Jeff Young <jyoung0950@xxxxxxxxx>]

Darren,
How would I put that in a variable used in PREPARE?
host_statement = 'select a,b,c,d, case :my_field when 1 then ... else ...
end from my_file' ;  ?

Jeff Young
Sr. Programmer Analyst

On Tue, Feb 24, 2015 at 4:11 PM, <darren@xxxxxxxxx> wrote:

> I do this all the time.  Here is an example from some code we're currently
> running:
>
>                case when :Sbm.Mode<>' ' then month(curdate()-1 month)
>                     else month(curdate()) end
>
>
> ___________________________________
> Darren Strong
> Programmer/Analyst
> Group Dekko, Inc.
>
>
>
>
>
> From:   Jeff Young <jyoung0950@xxxxxxxxx>
> To:     "RPG programming on the IBM i (AS/400 and iSeries)"
>             <rpg400-l@xxxxxxxxxxxx>
> Date:   02/24/2015 02:57 PM
> Subject:        Using host variable in embedded sql
> Sent by:        "RPG400-L" <rpg400-l-bounces@xxxxxxxxxxxx>
>
>
>
> All,
> Is there a way to use a host variable in a CASE statement as the field to
> be tested?
> ie: CASE :my_field WHEN .... END
>
> Would that work?
>
> Jeff Young
> Sr. Programmer Analyst
> --
> This is the RPG programming on the IBM i (AS/400 and iSeries) (RPG400-L)
> mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.
>
>
>
> --
> This is the RPG programming on the IBM i (AS/400 and iSeries) (RPG400-L)
> mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.