Can you see the function in Navigator? If so, you can get the exact
syntax by having it generate the SQL for creating it.
On 9/27/2012 12:36 PM, James Lampert wrote:
It was only three weeks ago that I did this before, but I don't remember
the exact CREATE FUNCTION syntax I used, and didn't document it
anywhere, and what I'm trying isn't working.
For an RPG function in a service program, prototyped as:
D CENSORACCT PR 1A
what's the syntax for the CREATE FUNCTION statement?
D IEID 9S 0
If I give it:
create function censoracct(numeric(9,0)) returns char language rpgle
parameter style general no sql program type sub external name censoracct
Clause not correct for procedure or function.
with the cursor on "general."
What am I doing wrong?