Question

Stored Procedures on AS/400

AS/400, Application development, DB2 universal database, PC/Windows Connectivity, RPG, RPGLE, Web development, Database, Oracle, DB2, SQL, SQL Server, Development, Web development tools, WebSphere Studio

Greetings,

I understand SQL stored procedures on the AS/400 generate C source code which is compiled to create a C ILE program object. I could use the same SQL statements in an RPGLE with embedded SQL program and use that to create a RPG stored procedure. Which of the two is more efficient?

Thanks for your input.

It depends on how you measure efficiency.
For example the generated C code is not as fast as well crafted code. However the user response time difference is likely to be trivial.
For developer efficiency, I can build, test and deploy 3 SQL stored procedures in a half hour while an RPG developer takes 2 days. Different skill sets, different tools have a big impact.
The important point for you to consider is that the RPG precompiler generates the same C code for the embedded SQL as the stored procedure does. How can you make that more efficient by wrapping it in a bunch of RPG code?