Using IBM i? Need to create Excel, CSV, HTML, JSON, PDF, SPOOL reports? Learn more about the fastest and least expensive tool for the job: SQL iQuery.
We are being asked to have a .NET SQL Server pgm directly execute a CL pgm on the iSeries. I can think of several ways to try doing this (SQL CALL? Stored Procedure?). But I thought I would ask here to see if any of you have a preferred way of doing this in your shops. The iSeries Access CLI extensions will not be installed on their server - just ODBC connections.