AW: SQL Function Returning a DATE failing on V6R1

Did you recreate your RPG and reregister your SQL under Release 6.1?

Mit freundlichen Grüßen / Best regards

Birgitta Hauser

"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them
and keeping them!"

-----Ursprüngliche Nachricht-----
Von: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] Im Auftrag von
Lennon_s_j@xxxxxxxxxxx
Gesendet: Wednesday, 20. January 2010 03:56
An: midrange-l@xxxxxxxxxxxx
Betreff: SQL Function Returning a DATE failing on V6R1

I have an RPG UDF that returns a date. It worked on V5R3 and V5R4. We
went to V6R1 a a couple of months ago and it no longer works.

It is registered like this using RUNSQLSTM:

DROP FUNCTION SLENNON/DATE_MDY
;
CREATE FUNCTION SLENNON/DATE_MDY
(INDATE DECIMAL(8,0) )
RETURNS DATE
PARAMETER STYLE SQL
LANGUAGE RPGLE
NO SQL
DETERMINISTIC
EXTERNAL NAME 'SLENNON/DATE_SQL(DATE_MDY)'
CALLED ON NULL INPUT
NO EXTERNAL ACTION

I can watch the RPG code in the debugger and it returns a date and the
null indicator is set to zero, but STRSQL (green screen) always shows
the replacement value (+s). SQuirreL (JBDC) always shows nulls.

What am I missing? Something seems to have changed in V6R1...