You should be able to find your previous statements by querying the QSYS2.SYSFUNCS table.
Select ROUTINE_DEFINITION from QSYS2.SYSFUNCS where ROUTINE_NAME='YOURFUNCNAME';
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of James Lampert
Sent: Thursday, September 27, 2012 12:36 PM
To: Midrange Systems Technical Discussion
Subject: What am I doing wrong on SQL CREATE FUNCTION? -- I should have documented how I did this before!
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
Clause not correct for procedure or function.
with the cursor on "general."
What am I doing wrong?
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/midrange-l