RE: Case stmt in SQL

["Bob Cozzi" <cozzi@xxxxxxxxx>]

I can't help you wit this but I've always wondered what a JDE julian date
format looked like. Can you give an example?
-Bob Cozzi


-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx]
On Behalf Of Wes
Sent: Wednesday, November 24, 2004 4:09 PM
To: rpg400-l@xxxxxxxxxxxx
Subject: Case stmt in SQL

I have a UDF (User Defined function) that takes a JDE julian date and
converts it into Gregorian date. In the table, some of rows julian date is
zero, so I'm using case statment to exculde them. But when I run it, my UDF
is still being called for zero dates and casuing an exception..

SELECT case when
       ALEFTB =  0 then current_date ELSE julian(int(ALEFTB))
        END
FROM f0116

Question is, why is julian UDF being called when ALEFTB is equal to zero?

Thanks, Wes






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