RE: Using host variable in embedded sql

This looks like a step back and rethink situation. You shouldn't need to use a host variable in a prepared statement, right. Don't build the statement until you have all the values needed. And by that logic, would you even need to use CASE, or would you simply be building a different statement for each value?

Kurt Anderson
Sr. Programmer/Analyst - Application Development, Service Delivery Platform

-----Original Message-----
From: RPG400-L [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Jeff Young
Sent: Tuesday, February 24, 2015 4:15 PM
To: RPG programming on the IBM i (AS/400 and iSeries)
Subject: Re: Using host variable in embedded sql

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.

--
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.