IT Jungle's Guru builds an IBM i web service that pages Db2 rows and caps each call at 500
Mike Larsen's RPG service, built with IWS and SQL JSON functions, takes an offset and a row count, clamps a negative offset to zero, returns at most 500 rows and tells the caller whether more remain. Any Db2 for i data an agent or MCP tool reads should come through a door like this, with the cap enforced on the server and the service running under a profile that holds only *USE on the tables it serves.
Built In.
The best of the log, every two weeks. One idea, one proof, one next step.
Built In.
The best of the log, every two weeks. One idea, one proof, one next step.
References do not imply endorsement. The link goes to the original source; the words are ours. Silver Lake Financial Group and Alder & Pine Home, where mentioned, are fictitious demonstration companies.