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...
As an Amazon Associate we earn from qualifying purchases.
	
 
This mailing list archive is Copyright 1997-2025 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact
[javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.