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

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