RE: call an RPG program

[Ron Mast]

Hmmm…lol…we had a Microsoft VB programmer come and work on getting Biztalk working for us and he called the AS400 mainframe…so I assumed since the guy was a genius, that he knew what he was talking about.  iSeries hit the spot though.  Yeah, we are using a Windows Based Server.  I was thinking stored procedure myself, but I have never ever done it and don’t know what to do.  You wouldn’t happen to have an example of how I can get stored procedure working on an iSeries backend?   Thanks, Ron            From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Knipp, Eric Sent: Wednesday, January 19, 2005 3:08 PM To: 'list@dfwcfug.org' Subject: FW: call an RPG program     Ron,   I am glad to hear there is another person on here using the iSeries as a back-end for an internet application!  It isn't a mainframe, by the way =).   There are myriad ways to invoke the call you are looking for; I will tell you about what we did at my company.   At UnitrinSpecialty, we're not calling RPG programs, but we are communicating with legacy COBOL applications, using data queues.  If you are using Windows as the platform for your ColdFusion application server, you should be able to connect to the AS/400 via the IBM iSeries Access data queue object.  We've written a COM wrapper in VB6 that uses this object for communications - I did try to use it directly from CFMX but with limited success.  On the iSeries side, we have a COBOL program that monitors for new activity in the data queue, and if it finds a key it will do some processing, and ultimately return a result into another data queue, which we're monitoring on the web server.   This method is working quite well for our WebRater application; we typically have several hundred users rating auto insurance policies at any given time with it.  Using data queues effectively allowed us to leverage our legacy batch rating programs for use on the web, and the best part is that there is no duplicated logic at all between the legacy rating system and the web system, so there's no chance for uprates or other problems that can occur when rating algorithms are maintained separately.   On a side note, when you say "build the file" I assume you are talking about populating a DB2 table with the information you seek to present; you mention this would be too slow in CF.  Stored procedures may be another option here, and those can be called from ColdFusion very easily.   Let me know what happens!  I am always interested in hearing about iSeries/CF integration adventures.   Thanks,   Eric Knipp Senior Programmer/Analyst Unitrin Specialty -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Ron Mast Sent: Wednesday, January 19, 2005 2:38 PM To: list@dfwcfug.org Subject: call an RPG program Hi All, I am pulling from an AS400 (Mainframe) database.  We are a manufacturing company so prices differ from customer to customer.  Our customers login and based on their customer number they only see items that they have purchased in the past with current prices.  Not so current though because the file I pull from was built last night.  There lies the problem.  We want to build this file as soon as the customer logs in.  It would simply take too long to build the file in CF, that is the reason why we are not doing it that way.  Does anyone know how to call an RPG program in CF?  The RPG program's purpose would be to build the file.    Ron       CONFIDENTIALITY NOTICE: The information contained in this e-mail and attached document(s) may contain confidential information that is intended only for the addressee(s). If you are not the intended recipient, you are hereby advised that any disclosure, copying, distribution or the taking of any action in reliance upon the information is prohibited. If you have received this e-mail in error, please immediately notify the sender and delete it from your system.