RE: call an RPG program

Kelly, Joe Wed, 19 Jan 2005 13:56:53 -0800

Title: Message

A year or so ago, a company called Team Studio sponsored a CFUG meeting. They had a tool designed specifically for this need called Screen Surfer. It’s a screen scraper. Any way, they sold it to this company.

http://www.inventu.com/SSIntro.html

It looked real easy to implement and worked great with CF and ASP. Coding was a snap, I think it was custom tags….

Thanks,

Joe Kelly

From: Lewis, David [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 19, 2005 3:47 PM
To: '[email protected]'
Subject: RE: call an RPG program

Here's what we did with our AS/400 --

Create stored procedures out of your CL programs by running a CREATE PROCEDURE command in the Interactive SQL area (STRSQL). You can probably find out what all the options are by looking up the create procedure command in an AS/400 SQL manual. You have to run this each time you recompile your program, I believe. You may also be able to use RPG programs if you want to skip the CL.

Example CREATE of CL program that takes a 12 character parameter:

Create Procedure LIBRARY/CLPROGRAM(INOUT RunOption CHAR (12))
Language CL Not Deterministic No SQL External Parameter Style General

Example of calling that stored procedure from CF:

I'm not enough of a guru to explain it thoroughly, but that should get you started if you want to try this route. Let me know if you need more details and I can pull some more code :)

-David

-----Original Message-----
From: Ron Mast [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 19, 2005 2:38 PM
To: [email protected]
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

RE: call an RPG program

Reply via email to