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
