RE: SQL - Using Case in Where clause

["Lim Hock-Chai" <Lim.Hock-Chai@xxxxxxxx>]

Still getting the same error.

     C/exec sql
     C+ declare C2 cursor for
     C+   select CLBLNO, CLCUNO, CLSFNO, CLCY, CLYR,
     C+          CLMO, CLDY, CLHR, CLMN, CLSC
     C+   from CSLOGPF
     C+   where
     C+      case
     C+         when filterType = 'FORM' then
     C+            CLFRMC = :SCFRMC
SQL0104: Position 27 Token = was not valid. Valid tokens: END.
     C+         else
     C+            null
     C+      end
     C+   order by
     C+      case :sortType
     C+         when 'STD' then
     C+            CLBLNO, CLCUNO, CLSFNO, CLCY DESC, CLYR DESC,
     C+            CLMO DESC, CLDY DESC
     C+         else
     C+            null
     C+      end
     C/end-exec         

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx]On Behalf Of Bob Cozzi
Sent: Monday, June 21, 2004 1:47 PM
To: 'RPG programming on the AS400 / iSeries'
Subject: RE: SQL - Using Case in Where clause


Why are you using ENDCASE?  It should just be "END" not "ENDCASE" I thought
I pointed that out already.
-Bob