Re: SQL Update using Variable Field

[rob@xxxxxxxxx]

Hence the "I don't have this worked out yet...".  It might not be 
feasible.

Rob Berendt
-- 
Group Dekko Services, LLC
Dept 01.073
PO Box 2000
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





"Michael Naughton" <mnaughton@xxxxxxxxxxxx> 
Sent by: rpg400-l-bounces@xxxxxxxxxxxx
03/05/2004 05:37 PM
Please respond to
RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>


To
RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>
cc

Subject
Re: SQL Update using Variable Field






Does this really work? I tried something like it in interactive SQL, and I
got a message saying that the keyword "WHEN" was not expected.

As other posts have already pointed out, if you're using embedded SQL then
you can build any statement you want using PREPARE . . .

RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx> writes:
>I don't have this worked out yet, but is this kind of what you are 
>thinking:
>UPDATE ROB/FELKER 
>SET 
> (case when current month= 1 then SAL01 = :MYVAR
>       when current month= 2 then SAL02 = :MYVAR
>       when current month= 3 then SAL03 = :MYVAR
>  END) 
>
>Rob Berendt


Mike Naughton
Senior Programmer/Analyst
Judd Wire, Inc.
124 Turnpike Road
Turners Falls, MA  01376
413-863-4357 x444
mnaughton@xxxxxxxxxxxx

_______________________________________________
This is the RPG programming on the AS400 / 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.