Q:
Stored Procedures on AS/400
AS/400, Oracle, PC/Windows Connectivity, SQL, RPG, DB2, Web development tools, Database, WebSphere Studio, Application development, RPGLE, Development, SQL Server, Web development, DB2 Universal Database 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.
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.
ASKED:
Aug 3 2006 10:58 AM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
A:
RATE THIS ANSWER
0
Click to Vote:
0
Click to Vote:
- 0
0
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?
