MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » September 2012

Re: What am I doing wrong on SQL CREATE FUNCTION? -- I should have documented how I did this before!



fixed

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






Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2014 by MIDRANGE dot 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 here. If you have questions about this, please contact