James
Can you see the function in Navigator? If so, you can get the exact
syntax by having it generate the SQL for creating it.
HTH
Vern
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
D IEID 9S 0
what's the syntax for the CREATE FUNCTION statement?
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
I get:
Clause not correct for procedure or function.
with the cursor on "general."
What am I doing wrong?
--
JHHL
