Midrange News for the IBM i Community


Posted by: SteveCCNJ
Software Engineer
Spencer Gifts
Egg Harbor Twp., NJ
Calling iSeries pgm from .NET pgm
has no ratings.
Published: 22 Mar 2013
Revised: 25 Mar 2013 - 3724 days ago
Last viewed on: 05 Jun 2023 (7365 views) 

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.

Calling iSeries pgm from .NET pgm Published by: SteveCCNJ on 22 Mar 2013 view comments(4)

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.

Return to midrangenews.com home page.
Sort Ascend | Descend

COMMENTS

(Sign in to Post a Comment)
Posted by: neilrh
Premium member *
Jackson, MI
Comment on: Calling iSeries pgm from .NET pgm
Posted: 10 years 2 months 15 days 23 hours 53 minutes ago
Edited: Fri, 22 Mar, 2013 at 15:17:39 (3727 days ago)

Usually go with Stored Procedure for all the corps I've worked with. But I'm the i-side dude, so I don't deal with the .NET stuff - just the RPG/CL code.

Though sometimes the Stored Procedures are my domain (they're on the AS/400 and .NET folks get scared of computers that don't need to be rebooted every couple hours), where other times I just write the programs and the Stored Procedures are the "web people" thing. As I noted recently, both splits in domain can have issues when uses/reads/modifies SQL DATA comes into play.

Posted by: SteveCCNJ
Premium member *
Egg Harbor Twp., NJ
Comment on: Calling iSeries pgm from .NET pgm
Posted: 10 years 2 months 15 days 21 hours 54 minutes ago

Without the iSeries Access CLI stuff they seem to be having problems invoking the Stored Proc.  So here's what I'm going to try:

Create a table for them to insert a row with a specified request.  Attach a Trigger Pgm to the table to respond to Inserts only.  The Trigger Pgm will do the requested Call and will send them a SQL Server trigger file in return (go file) when their results are ready.  I'll try this early next week.

 

Posted by: clbirk
Premium member *
Comment on: Calling iSeries pgm from .NET pgm
Posted: 10 years 2 months 14 days 21 hours 59 minutes ago

do you have a webserver active on the ibmi? You could have the .net program call a webservice/page that would trigger the calling of the "i side commands" you want to do, and then return back the information.

 

chris

Posted by: Ringer
Premium member *
Comment on: Calling iSeries pgm from .NET pgm
Posted: 10 years 2 months 13 days 5 hours 18 minutes ago

Sounds like a "hack" to me, using a trigger for a a request and response. Can you turn the RPG into a SOAP web service using the IWS? Then .net could consume a SOAP web service. The one drawback (or used to be?) is that the RPG parms are rigid, the client/agent can't send variable length data.

Chris Ringer