Managing SQL Procedures

Hey, David:

We are having problems resolving calls from the Web via ODBC to ILE RPG programs on the iSeries. The IBM tech we talked to yesterday recommended we have external SQL procedures defined for any call. I added one through Operations Navigator and the call worked fine after that. He indicated that using Operations Navigator wasn't the best way to maintain those, and that when you change and recompile the RPG you have to rebuild the SQL definition. I know the definitions are stored in SYSPROCS and SYSPARMS. He recommended some other method of entering these, and to save them to another file somewhere. What do you use for maintaining SQL procedure definitions?

READ MORE >

Function Signatures and Parameter Matching

Hey, Howard:

We've been using an ILE RPG procedure to return cost information from our product master file. The procedure returns a 13,6 decimal cost using 15 char product, 1 char standard (Base, Current, etc.), 1 char type (Mat, Lab, Ovr, Tot), and 1 char level (This, Prev, or Both) as input. This has been working very well for us in RPG. The input parameters are all defined as CONST.

READ MORE >

Reader Feedback and Insights: Too Many Duane's

Hey, Ted:

I think there are two of us Duane's going at IBM in your column, and it may be confusing to some. I appreciate your column and letting us vent our frustrations and occasionally getting some good feedback.