Re: More, Re: What am I doing wrong on SQL CREATE FUNCTION? -- I shouldhave documented how I did this before!

After creating and testing the SQL function, I always cut and paste the CREATE FUNCTION statement which was used to create the function and place it as a series of comment lines in the source code of the RPG program which contains the function being referenced.

- sjl


wrote in message news:mailman.3771.1348769007.2683.midrange-l@xxxxxxxxxxxx...

I am BCC'ing you for some screen shot.

For future reference, as soon as you've done it in STRSQL, store it in a
source member in a source physical file. You can rerun it with RUNSQLSTM
on any machine regardless of the presence of 57xx-ST1 (which is the lpp
with STRSQL).

To decompile a function which exists on another system you open up iNav,
YourIBMi, Databases, YourIBMi, Schemas, YourLibrary, Functions. Find the
function you want. Right click on it and select Generate. It defaults to
opening up in iNav's RunSQL scripts.

If this is too productive for you, you can always try to find a 5250 way
to do it. One possible method is:
http://publib.boulder.ibm.com/infocenter/iseries/v7r1m0/topic/apis/qsqgnddl.htm

Screen shot 1 of 2


Screen shot 2 of 2



Rob Berendt