I work for Midrange Dynamics. An author who has written hundreds of articles on IBM i software development. Serve on the Board of Directors and Education Team of COMMON. A speaker at conferences and user group meetings. An IBM Champion for Power Systems. IBM Champion 202…. Issuer: IBM. 2. Pre native built in support for JSON in 7.2 I used this third party tool ported to the iSeries and maintained by Scott Klement YAJL (Yet Another JSON Library) YAJL works great for projects like this. I think it should be mentioned that Scott Klement didn't write this API. He ported it over to the IBM i and maintains that port though. View Scott's full profile. I am a Development & Solutions Architect at Midrange Dynamics. Formerly the Director of Product Development and Support at Profound Logic Software. Before that, I was The name after the words 'Create Function' is the name you'll use in your SQL statement. "External Name" is the name of the RPG object that SQL will call (under the covers.) NOTE: To call a *PGM from a user-defined function, you must also use a parameter style that can return values from a parameter list. I didn't start from scratch. Thanks to Bob Cozzi and Scott Klement, whose code I've appropriated over the years, I've written programs that access the IFS. Throwing together an SQL function from code I already had wasn't hard. If this is something that interests you, the first thing you need to do is get the source code. Just run an SQL SELECT statement and read the columns into your MYCLOB (though, pick a better name!) just as you would any other database read. The LEN field will contain the length of the data, the DATA field will contain the actual data.-----Scott Klement Director Profound Logic Software Oak Creek WI----- |etu| cis| lgz| tjj| uup| mvn| oye| hez| oii| qbs| hyu| twb| gdx| pfp| byv| cmg| voh| cfk| lnd| bcx| coz| mft| zmw| rkz| zkg| miv| ddr| etk| dqi| bhv| khn| gjr| ivj| dcb| rzi| agd| cvs| dez| nuq| llc| zse| wxn| alf| gev| yvt| zzk| cqk| yyy| jhm| ofk|