TechTip: Speed Up SQL Procedures with Service Program Support

[dwhitehouse@madico.com]

** This thread discusses the Content article: TechTip: Speed Up SQL Procedures with Service Program Support **
This thread discusses the Content article: TechTip: Speed Up SQL Procedures with Service Program Support Kent, Can C generated service programs created by SQL be used directly in an RPG program (having mapped the parms correctly) - or, can they only be called via embedded SQL? If so, what issues may one encounter with mapping RPG & C parms? Daron

[K.Milligan]

Re:TechTip: Speed Up SQL Procedures with Service Program Support

The C program & service program objects generated by SQL procedure must be called with an SQL CALL statement. There are several hidden parameters that the SQL CALL interface handles and processes.

[dwhitehouse@madico.com]

Re:TechTip: Speed Up SQL Procedures with Service Program Support

That would figure. As a rule, when a function is deemed usable for both SQL and RPGLE, we will create an RPG subprocedure and then an SQL stored procedure of function wrapper which to call the subprocedure. Is this common practice? Thanks

[K.Milligan]

Re:TechTip: Speed Up SQL Procedures with Service Program Support

I've heard of customers sharing SQL procedures in a similar manner. However, usually the SQL users of the procedures are on remote clients. Are you using SQL procedures instead of SQL embedded in RPG programs because the coding is simpler?