Re: Can anyone explain this?

Hi Mike
what's interesting is that BOTH fields are either changed or unchanged and
ONLY when its a N N combination
As you have posted only a portion of the sql statement, is it possible that
the case statements are NOT reached upon certain conditions?



Alan Shore
Programmer/Analyst, Direct Response
E:AShore@xxxxxxxx
P:(631) 200-5019
C:(631) 880-8640
"If you're going through Hell, keep going" - Winston Churchill




Mike
<koldark@xxxxxxxx
m> To
Sent by: rpg400-l@xxxxxxxxxxxx
rpg400-l-bounces@ cc
midrange.com
Subject
Can anyone explain this?
01/12/2010 03:21
PM


Please respond to
RPG programming
on the IBM i /
System i
<rpg400-l@midrang
e.com>






I am working on an SQL statement with few CASE statements. I am getting
unexpected results.

Portion of SQL statement:
CASE C.ASTOCK WHEN 'N' THEN 'No' WHEN 'Y' THEN 'Yes' END,
CASE C.AFUEL WHEN 'N' THEN 'No' WHEN 'Y' THEN 'Yes' END,

Data before CASE added:
STOCK FUEL/OIL
PART IF Y PART IF Y
N N
Y N
N N
N N
Y N
Y N
Y N
Y N
Y N
Y N
N N
N N
Y N
Y N
Y N
Y N
N N
Y N

Data after CASE added:
CASE expression CASE express

No No
Y N
No No
No No
Y N
Y N
Y N
Y N
Y N
Y N
No No
No No
Y N
Y N
Y N
Y N
No No
Y N


Ever seen this before? Any ideas where to even start? We are migrating this
application data from the iSeries to a new system. I am trying to avoid
writing a program if possible.

--
Mike Wills
http://mikewills.info
P: (507) 933-0880 | Skype: koldark
--
This is the RPG programming on the IBM i / System i (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.