Turnover (the one written by Softlanding that does Change Management, not the one that is full of apple and tastes delicious) is a pretty cool Software Change Management application native to IBMi. But of course, you already knew that.
But, did you know that you can promote an EXTERNAL PROCEDURE to a specific library and then have it invoke its program component from that library, or from any library that you care to define to Turnover or of course from the *LIBL?
It’s all down to these basic rules:
Example *EXTPRC using &LIBRARY VARIABLE:
CREATE PROCEDURE CHKCASACT(OUT ACCOUNTNUM9 DEC(9,0),IN BIRTHDATE DEC(6,0),IN DRIVERSLIC CHAR(25),IN DRIVERSLICSTATE CHAR(2),IN PASSPORTID CHAR(20),IN OTHERID CHAR(30),IN RZIPCODE CHAR(15),IN LASTNAME CHAR(25),IN FIRSTNAME CHAR(25),IN RADDRESS1 CHAR(25),OUT RETURN_CODE CHAR(25),OUT RETURN_MSG CHAR(100))DYNAMIC RESULT SETS 2LANGUAGE RPGLESPECIFIC CHKCASACTNOT DETERMINISTICMODIFIES SQL DATACALLED ON NULLINPUT EXTERNAL NAME ‘&LIBRARY/CHKCASACT’PARAMETER STYLE GENERAL ;
And of course to change that external name to :
EXTERNAL NAME CHKCASACT
will result in it calling it from the *LIBL
It took me a lot of head scratching to figure it out… and YES…. I know I probably could have just opened a manual and found that out. 🙂
IBM i Software Developer, Digital Dad, AS400 Anarchist, RPG Modernizer, Alpha Nerd and Passionate Eater of Cheese and Biscuits. Nick Litten Dot Com is a mixture of blog posts that can be sometimes serious, frequently playful and probably down-right pointless all in the space of a day. Enjoy your stay, feel free to comment and in the words of the most interesting man in the world: Stay thirsty my friend.
Don’t hardcode library names in your TURNOVER SQL source #youbigsilly
How to rename Fresche (BCD) Presto Library – XL_PRESTO
Using TURNOVER in an IBM i iASP Environment
Turnover 3 – Promoting RPG using Turnover Forms
Turnover 2 – Checking out code, editing and compiling using the Programmers Work list
Turnover 1 – Using iSeries Projects and Tasks
Softlanding Turnover – Change Management Roles and Responsibilities
Turnover and External Procedures are twisting my melon, Man!
Going the (Levenshtein) Distance in RPG Free