55 pts.
 SQLRPGLE
what is the difference to update a file using rpgle/ sqlrpgle program?

Software/Hardware used:
AS400
ASKED: November 20, 2012  5:42 AM

Answer Wiki:
The main difference is that when using rpgle, you are restricted to doing one record at a time processing; whereas with sqlrpgle, you can use SQL statements and processed multiple rows with a single command.
Last Wiki Answer Submitted:  November 20, 2012  12:22 pm  by  CharlieBrowne   32,785 pts.
All Answer Wiki Contributors:  CharlieBrowne   32,785 pts. , mcasantoshrai   55 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _


 

The question doesn’t make much sense. First, “rpgle” and “sqlrpgle” are nothing more than types that have meaning to PDM and SEU. You can use any “type” you want, and it won’t change requirements for code in the program. You can code both to look exactly the same if you wish, no difference at all. But second, “sqlrpgle” normally uses SQL and “rpgle” doesn’t, which is pretty clearly indicate by the “type”. What exactly do you need to know? — Tom

 107,845 pts.